Date function - (now - 30days)?

[Antony3]

Hi all,

I am struggling a little bit with the date functions in the Automation tool. Self teaching here so getting a bit turned around. 

I have a formula (below) where I get the year-day of today i.e. '2024-01'. How do I update the formula so it looks at last month? Each month I look back at data from the last month so I need it to be dynamic. The result expected here should be '2023-12'

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/working-with-...

[Antony3 · Accepted solution]

For those who may be interested. I literally stumbled on the solution in another post.

https://community.qlik.com/t5/Qlik-Application-Automation/Add-months-and-years-in-Qlik-Application-A...

Instead of 'now' you can write 'last month'. 

See the response by Emile with the condition formula.