Hi All,
I have a report which uses date prompts. The prompts are 'Begin Date' and 'End Date'. Now, in the title of the report i would like to have the 'End Date' prompt value displayed as 'End Date'-1. Ex: Title between 'Begin Date' and 'End Date-1' . Can someone let me know how to do this day subtraction.
Thanks!!
Is your date prompt a date range prompt?
Hi Darek, thanks for your reply. It is just a Date prompt, not a range.
In that case you can use a simple dateadd function to add -1 days to your End Date prompt and place t on the report as a report level calculation.