superdatepattern(
SUPERDATE
,
DATEPATTERN
,
TIMEPATTERN
)

The superdatepattern( function converts a number containing a superdate to text, allowing you to specify the patterns for both the date and the time conversion to text.


Parameters

This function has three parameters:

superdate – is a number that combines the date and time into a single value. See the superdate( function.

datepattern – is text that contains a pattern for formatting the date (see Date Patterns)

timepattern – is text that contains a pattern for formatting the time (see the timepattern( function).


Description

This function converts a number containing a superdate to text, allowing you to specify the patterns for both the date and the time conversion to text.

superdatepattern(supernow(),"Month ddnth, yyyy at ","hh:mm am/pm") ☞ September 5th, 2013 at 6:55 PM
superdatepattern(supernow(),"MM/DD/YY @ ","hh:mm:ss am/pm") ☞ 9/5/13 @ 6:55:33 PM

Note: This function is equivalent to:

?(thedate=0,"",datepattern(regulardate(thedate),dpattern)+
    timepattern(regulartime(thedate),tpattern))

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.