Hello,
I want to scedule a query (every day) and send as pdf to email-users. This pdf-attachment; I can give it a name and add date. Now this date is a formula %STARTDATETIME%. I want to change this date in 'yesterday' and I don't want the time. I also want the date in format ''dd-mm-yyyy''.
Example of the name: Daily figures 16-2-2009
I don't know how to do that, something like %STARTDATETIME%-1, dd-mm-yyyy ?????
Lia