TOPIC: Additional date and time variables (past dates)
Additional date and time variables (past dates)
09 Jun 2015 19:27 #1969
mholbrook
Offline
Hello,
You can use vbscript in order to code the month. So for example you could use the code below. Thanks!
Matt
%{DateAdd("m", -1, DATE )}%
The administrator has disabled public write access.
Additional date and time variables (past dates)
27 Oct 2015 17:26 #2057
RonMoses
Offline
We definitely need Current Hour (Leading Zero) and Current Minute (Leading Zero). Running a report at 8am and having 80 show up as the timestamp in my file name does me no good.
EDIT: Disregard. The RIGHT("0" + DATEPART()) method works fine.
Last Edit: 27 Oct 2015 17:44 by RonMoses. Reason: I'm a bonehead.
The administrator has disabled public write access.
Additional date and time variables (past dates)
17 Jun 2016 19:34 #2306
flowersrj
Offline
MONTHNAME would be nice too. Examples: January or February
The administrator has disabled public write access.