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
- alphabeticnumber( -- converts a number into letters: A, B, C, etc.
- asc( -- converts the first character of a text string into a number from 0 to 65535 based on Unicode encoding.
- bigendianbinaryvalue( -- converts big endian binary data (a byte, word, or longword) into an unsigned number (see Binary Data).
- binarytotext( -- converts binary data into text, optionally using a specified encoding.
- binaryvalue( -- converts binary data (a byte, word, longword, or longlongword) into a number (see Binary Data).
- booleanvalue( -- converts a numeric or text value to Boolean (true/false).
- boolstr( -- converts a Boolean value to text, either `"true"` or `"false"`.
- bytepattern( -- converts a byte count to text: 543 Bytes, 543 Kb, 123 Mb, 3.2 Gb
- calendardate( -- helps in creating monthly calendars.
- calendarday( -- helps in creating monthly calendars.
- chr( -- converts a number into a single character of text, based on Unicode encoding.
- commalist( -- converts a text array (see Text Arrays) into an English list, with items separated by a comma and a space, except for the last two items which are separated by the word *and* and spaces.
- commastr( -- converts a number to text, with a comma every third digit. The number is converted as an integer, with no decimal point.
- completedatestr( -- converts a date to text, spelling out the month and including the day of the week.
- converttimezone( -- converts a time or superdate from one time zone to another.
- custompluralpattern( -- converts a number to text using a pattern, making customizable adjustments for pluralization.
- Date Patterns -- control how dates are displayed or converted to text.
- date( -- converts text into a number representing a date.
- datepattern( -- converts a number representing a date into text. The function uses a pattern to control how the date is formatted (see Date Patterns).
- datestr( -- converts a date to text using format *mm/dd/yy*.
- datevalue( -- converts integer values for year, month and day into a number representing a date.
- daylightsavingstimeoffset( -- returns the current daylight saving time offset of the specified time zone.
- dayofweek( -- computes the day of the week, with Sunday being 0, Monday 1, etc.
- daystr( -- converts a date to the day of the week (for example *Sunday*).
- dayvalue( -- extracts the day from a date as a numeric value.
- dollarsandcents( -- converts a number to text formatted as dollars and cents.
- emojicheats( -- abbreviates any emojis with "emoji cheat" codes.
- encodeurlfragment( -- encodes text so that it can be used in the fragment portion of a URL (the portion after the # symbol).
- encodeurlhost( -- encodes text so that it can be used in the host portion of a URL (for example www.host.com).
- encodeurlpassword( -- encodes text so that it can be used in the password portion of a URL.
- encodeurlpath( -- encodes text so that it can be used in the path portion of a URL (the portion after the host name, but before any ? symbol).
- encodeurlquery( -- encodes text so that it can be used in the query portion of a URL (the portion after the ? symbol).
- encodeurluser( -- encodes text so that it can be used in the user name portion of a URL.
- eurodatestr( -- converts a date to text in European format.
- expandemojis( -- expands any "emoji cheat" abbreviations into the actual emojis.
- firstdayofweek( -- returns the user's preference for first day of the week.
- formatphone( -- formats a US phone number using the standard *(aaa) nnn-nnnn* format.
- groupdatepattern( -- converts a number representing a date into text in a special format for use with the summarytable( and crosstab( functions. The function uses a pattern to control how the date is formatted (see Date Patterns).
- hex( -- converts a text item containing a hexadecimal number into a standard number (decimal).
- hexbyte( -- converts a limited range of decimal numbers to a two-digit hexadecimal number expressed as a text string.
- hexlong( -- converts a decimal number to an eight-digit hexadecimal number expressed as a text string
- hexstr( -- converts a number to text formatted as a hexadecimal number.
- hextobinary( -- converts a sequence of hexadecimal digits into a raw binary data value.
- hexword( -- converts a decimal number to a four-digit hexadecimal number expressed as a text string.
- importcell( -- returns one cell of imported data.
- info("defaultfloatformat") -- returns the default format for converting floating point numbers to text.
- info("localtimezone") -- returns the local time zone for the current location of your computer.
- info("milliseconds") -- returns the number of milliseconds (1/1000th second) since the system started up.
- info("tickcount") -- returns the number of ticks (1/60th second) since the system started up.
- info("timezoneabbreviations") -- returns a dictionary of time zone abbreviations supported by the system.
- info("timezones") -- returns a list of time zone regions recognized by the system.
- length( -- counts the number of characters in a text value (also called a string).
- littleendianbinaryvalue( -- converts little endian binary data (a byte, word, longword, or longlongword) into an unsigned number (see Binary Data).
- longdatestr( -- converts a date to text by spelling out the month.
- longtimestr( -- converts a number to text in am/pm time format, including seconds.
- money( -- converts a number to text, formatted as money.
- month1st( -- computes the first day of a month.
- monthlength( -- computes the length (number of days) of a month.
- monthmath( -- takes a date and computes the date that is one or more months before or after the original date.
- monthvalue( -- extracts the month from a date as a numeric value.
- naturaldate( -- converts a number representing a date into text using "natural" formatting.
- nextdaylightsavingstimetransition( -- returns the next date on which a transition to or from daylight savings time occurs.
- now( -- returns the current time (number of seconds since midnight).
- nth( -- converts a number into an ordinal.
- Numeric Patterns -- control how a number is displayed or converted to text.
- pattern( -- converts a number into text using a pattern.
- places( -- converts a number to text with a specific number of places after the decimal point.
- pluralpattern( -- converts a number to text using a pattern, making adjustments for pluralization.
- pointsval( -- converts a dimension to points (possibly from inches or centimeters).
- quarter1st( -- computes the first day of a quarter.
- quartervalue( -- extracts the quarter from a date as a numeric value.
- radix( -- converts a text item containing a number in a radix between 2 and 36 into a decimal number.
- radixstr( -- converts a number into a text item containing the equivalent number in a radix between 2 and 36.
- regulardate( -- extracts a regular date (number of days from January 1, 4713 B.C.) from a superdate.
- regulartime( -- extracts a regular time (seconds since midnight) from a superdate.
- scientificnotation( -- converts a number to text, formatted in scientific notation.
- secsminshours( -- this converts a time (number of seconds) into an approximate text value.
- setdefaultfloatformat -- sets the default format for converting floating point values to text (unsupported).
- signedbinaryvalue( -- converts binary data (a byte, word, longword, or longlongword) into a signed number (see Binary Data).
- str( -- converts a number into text, with no formatting.
- superdate( -- converts a regular date and a regular time into a superdate.
- superdatesecondsstr( -- converts a number containing a superdate to text, including the seconds.
- superdatestr( -- converts a number containing a superdate (date + time) to text.
- supernow( -- returns the number representing the current date and time as a superdate.
- texttimedifference( -- allows time math to be performed on text values.
- texttimeinterval( -- allows time math to be performed on text values.
- texttobinary( -- converts text into binary data, optionally using a specified encoding.
- time( -- converts text into a number representing a time.
- time24( -- takes a time and makes sure it falls within a 24 hour period.
- timedifference( -- calculates the difference between two times. It works correctly even if the interval between the two times crosses over midnight.
- timeinterval( -- calculates the time interval between two times. It works correctly even if the interval between the two times crosses over midnight.
- timepattern( -- converts a number representing a time into text. The function uses a pattern to control how the time is formatted.
- timestr( -- converts a number to text in am/pm time format.
- timezoneabbreviation( -- returns the abbreviation of the specified time zone.
- timezonename( -- returns the continent and city of the specified time zone.
- today( -- returns a number corresponding to today's date.
- val( -- converts text into a number.
- week1st( -- computes the first day of a week (Sunday).
- weekvalue( -- extracts the week from a date as a numeric value.
- year1st( -- computes the first day of a year.
- yearvalue( -- extracts the year from a date as a numeric value.
- zbpattern( -- converts a number to text using a pattern, but returns empty text if the number is zero.
History
| 10.0 | No Change | Carried over from Panorama 6.0. |