This ties back to the automation thread I had yesterday, but it’s something new. So far everything works perfectly, except for an issue with the way minutes are handled.
These are my variables:
Variable 2 Name: Time Value: DatePart("h", Now) & DatePart("n", Now)
These variables are used as part of the Output file name:
The issue that we’re seeing is that when the report runs at the top of the hour, which it’s setup to do, the hour is captured in 24HR format (ie. 14 for 2pm), but the minutes are captured as a single digit - this is the file name generated at the 2:00 PM (1400) report:
When what we really want is:
I understand it’s a fairly trivial difference, but these reports are used for auditing purposes, and any discrepancy could be taken the wrong way. So, is there anyway to force the time to pad zeros?