Identify a Time Frame for Month Prior Filtering

[tim_koirtyohann]

I need to filter a data set for jobs filled in the month prior to the current month.

Ex: In May, I need to filter a report of jobs filled over an extended period of time to ID only filled in April of current year, in June for jobs filled in May, etc.

I don’t want to have to edit the timeframe each time I run it so I need a way to ID the month prior to the current month.

I created a column (Current Month) with the Formula Tool and DateTimeFirstOfMonth() to identify the first the current month. How do then ID the month before that date? Since months can have 28, 29, 30, or 31 days, what would be the best method?

[ed_hayter · Accepted solution]

Datetimeadd([Current month], -1, "month") should add a column with the value being the first of the prior month

[tim_koirtyohann]

Thank you, I knew it had to be easier than I thought.