 |
|
|
DateFormat() Converts a date into a string of a particular format. Syntax DateFormat(<dDate>, <nType>, [<cBracket>]) --> cDateString Arguments <dDate> --> is the date field to format. <nType> --> is the number of the formatting to apply to the date. See the table below for more details. <cBracket> is the bracket character to use which separates the day, month and year components of the date. This should be a character or symbol. For example: / : - .
If not specified the forward slash (/) symbol is used by default. Returns Returns a new character string based on the specified date format. Description This function accepts a date and formats it for presentation based the type of formatting specified. It can be used to convert an Australian date into the date format of another country, such as US or Japanese.
Examples DateFormat(Invoice->Date, 4, '-') DateFormat(Sorders->Sodate, 5, '.') DateFormat(Today(), 9) ____________________________ Related Topics |
Numbers cannot be used as symbols.