I have several reports that I am running automatically via subscriptions and they are being placed in a Windows File Share location. I currently have them set to autoincrement the name of the file, but want to change it to include the date - and only the date - on the end of the file.
So I want
Daily Report 2007-06-06.pdf
I found some vague references to using @timestamp as a variable, which does work, but I don't need the time info. I just want the date. I have tried @date, @Date, @GetDate(), etc.
Anyone done this and can guide me??? Thanks.
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer
So I want
Daily Report 2007-06-06.pdf
I found some vague references to using @timestamp as a variable, which does work, but I don't need the time info. I just want the date. I have tried @date, @Date, @GetDate(), etc.
Anyone done this and can guide me??? Thanks.
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer