datestr(

DATE
)


The datestr( function converts a date to text using format mm/dd/yy.


Parameters

This function has one parameter:

date – a date to convert (usually created with the today() or date( functions).


Description

Convert a date to text using format mm/dd/yy.

datestr(today()) ☞ 9/3/13
datestr(date("last tuesday")) ☞ 8/27/13
datestr(date("friday")) ☞ 9/6/13

As shown above, if the month or day is a single digit, no leading zero will be added. If you want the leading zero, use this function:

datepattern(number),"MM/DD/YY")

See the datepattern( function for additional information.

Note: This function is equivalent to:

datepattern(thedate,"mm/dd/yy")

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.