Previous month of File Modification date

[Lucky1]

Hi team

I have used filetime() to get  file modification date.but i want previous month of File Modification date how can I get that.

Example if my file modification date is March 2023 my dashboard should show feb 2023.

I have tried filetime()-1  as prevmodifidate(it's not working)

[Rams- · Accepted solution]

Hi,

you can you use this expression in your script:

AddMonths(filetime(),-1) as filetime

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!