Substract from Date Prompt

[ghostraider]

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!!

[Darek]

Is your date prompt a date range prompt?

[ghostraider]

Hi Darek, thanks for your reply. It is just a Date prompt, not a range.

[Darek]

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.