Dynamic Date Range: Rolling 12 Months - Prev Month

[ansh09]

I'm trying to build a dynamic date range to filter on a rolling 12 months - end of the previous month.

For example: Today is 2/06/2025, so I want my date filter to show 1/1/2025 - 1/31/2025.

And everytime when ever i run my workflow on a monthly basis it should automatically takes the "Start" and "End" Date of the previous month, irrespective of the number of days in a month (30,31 or 28). 

Thanks for your help. 

[PangHC · Accepted solution]

[ansh09]

after applying this it is giving me an error saying " the formula "DUE DATE" resulted in a integer but the field is a Date/time 

how to resolve? 

[davidskaife]

Hi @ansh09 

You're applying a logical calculation onto a Date field, if you create a new field instead that should fix it

[ansh09]

I did that
but i am not getting the required output , I guess i would need to use it in Filter tool so that only required rows should come up.

[davidskaife · Accepted solution]

If you're using that formula to filter then yes a Filter tool will be required, that should restrict it to just those records you need.

Alternatively create a new flag field using the formula, and filter on the flag.