• Page:
  • 1
  • 2

TOPIC: Additional date and time variables (past dates)

Additional date and time variables (past dates) 09 Jun 2015 19:27 #1969

  • mholbrook
  • mholbrook's Avatar
  • 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
  • RonMoses's Avatar
  • 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
  • flowersrj's Avatar
  • Offline
MONTHNAME would be nice too. Examples: January or February
The administrator has disabled public write access.
  • Page:
  • 1
  • 2

Logicity Logo White 300

526 S Main St., Suite 805, Akron, OH 44311 USA
855.758.0100
sales@logicitysuite.com