Identify a Time Frame for Month Prior Filtering
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Datetimeadd([Current month], -1, "month") should add a column with the value being the first of the prior month
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, I knew it had to be easier than I thought.
