October 3, 2005 at 5:11 am
How do I enter an expression like: ="data as at " & format("dd/MM/yyyy hh:mm:ss)? I can format the text box OK, but that won't help.
October 3, 2005 at 11:11 pm
I would say you're close already, don't you just need to add *something* to be formatted to the Format function? I can't remember the syntax but something like ="today is " & Format(Now(), "dd/MM/yyyy hh:mm:ss") should be close(ish).
Steve.
October 4, 2005 at 8:51 am
Looks like you are trying to show current date and time, if so, just use Global parameter "ExecutionTime" (i.e. =Globals!ExecutionTime). It shows date/time in your mentioned format.
October 5, 2005 at 2:11 am
That works fine, thanks guys.
October 31, 2005 at 9:15 am
Could someone help me pull the DayOfWeek from the ExecutionDate? I need something like:
Monday, 10/31/2005. I am having touble getting just the day of week section.
October 31, 2005 at 9:22 am
try:
format(Globals!ExecutionTime,"dddd, MM/dd/yyyy")
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply