Forum Discussion
Date Pick-List Question
I have an accounts receivable report that has an "as of" date picker. Every time a user opens the report the most recent date is the last one chosen. Does anyone know of a way for the default date to be the most current date? For example, if a user openned the report on May 29th and selected this date from the drop-down, then closed the report, and reopened it a day later, the 29th is the date selected. Ideally, I would like it to be the 30th. I thought about creating a derived table with the most current date -- Today() -- and then adding it to the data model, but I'm not sure that's optimal.
Thanks.
If its a date slicer, you can make it a releative date slicer, so it will always open for the current date, or show yesterdays data as default.
2 Replies
- JorgastResolver II
If its a date slicer, you can make it a releative date slicer, so it will always open for the current date, or show yesterdays data as default.
- tlenzmeierHelper II
Thanks! Duh, is my lingering thought. So simple you could slap me upside my head.