Skip to Content
0
Former Member
Feb 17, 2009 at 09:06 PM

question about scheduler and name of attached file

15 Views

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