Get Previous Month and Year (Variable Expression)

[bruno29a]

Hi @mmngeoh , you can get the current day also, and just do current date - current day, it should give you the last day of the last month, and then simply apply your slice() on that generated date.

Alternatively, you use the Data&Time Shift node for this. Check this thread where I used this node with the above logic:

Name Excel file with last day of last month

Hi @RapplK , something like this could do: [image] When working with Dates, or rather manipulating Dates, it’s best to work with the Dates nodes rather than manually moving days. The logic I used to get the last day of previous month is to simply take current date minus the current day. So if today is 2022-03-14, the current day is 14, and if you do 2022-03-14 - 14 days, you get the last day of the previous month. Elaborating the workflow: First, I create a variable where I can add the tem…