Please help me if i could append time stamp to SSRS report subscription. Time stamp should be in YYYYMMDD format. 'ReportName @timestamp' is giving me timestamp in 2017_03_17. My Datasource is oracle.
I appreciate your help.
Asked
Active
Viewed 232 times
0
-
In Oracle you format the date like this: `TO_DATE(SYSDATE, 'YYYYMMDD')` – StevenWhite Mar 17 '17 at 20:47
1 Answers
0
If this is for file names in subscriptions in SSRS, then no.
https://msdn.microsoft.com/en-us/library/ms160334.aspx gives a list of all available variables for names (@ReportName & @ExecutionTime for emails, @TimeStamp for fileshare).
BishNaboB
- 1,047
- 1
- 12
- 25