Filtering Changing dates
- 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 create a workflow that filters for only the next weeks dates. so if I ran it today 08/29/24 I would need to filter for dates 09/03-09/06/24. is there a way to add this to the run screen in the server as it will need to selected each time it is ran.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @sericson
You can add a Date select to the user interface, however it is not needed if you will use Today as the based date.
You can add in a Formula tool Today() and it will be always taking the current date, then you can set with additional formula any future dates.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sericson
can you please elaborate on the requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
how would I set the formula for the changing future dates?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Raj, I need to be able to filter to only view the next weeks dates on a report. the original report contains dates for the entire year but I want to only view on week at a time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DateTimeAdd(dt,i,u)
dt - Today date
i - how many days to add
u- "days"
