Date function - (now - 30days)?

Antony3 — Mon, 08 Jan 2024 16:17:25 GMT

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-automations/date-functions.htm

Re: Date function - (now - 30days)?

Antony3 — Mon, 08 Jan 2024 19:23:51 GMT

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-Automation/td-p/1929432

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

See the response by Emile with the condition formula.