LassoScript Utility
Basics Browse Detail


Tag Link [Date_Format] Category Date
Type Substitution Source Available No
Support Preferred Version 3.0
Change Unchanged Data Source Any
Output Type String Security None
Implementation LCAPI Sets Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0, Lasso 3.x


[Date_Format] outputs a Lasso date string or Lasso date data type in any format.

The first parameter should be a Lasso date data type or a string in Lasso date format. The -Format keyword/value parameter defines how the date should be formatted.

%D U.S. date format (mm/dd/yyyy).
%Q MySQL date format (yyyy-mm-dd).
%q MySQL timestamp format (yyyymmddhhmmss).
%r 12-hour time format (hh:mm:ss [AM/PM]).
%T 24-hour time format (hh:mm:ss).
%Y 4-digit year.
%y 2-digit year.
%m Month number (1=January, 12=December).
%B Full English month name (e.g. "January").
%b Abbreviated English month name (e.g. "Jan").
%d Day of month (1-31).
%w Day of week (1=Sunday, 7=Saturday).
%W Week of year.
%A Full English weekday name (e.g. "Wednesday").
%a Abbreviated English weekday name (e.g. "Wed").
%H 24-hour time hour (0-23).
%h 12-hour time hour (1-12).
%M Minute (0-59).
%S Second (0-59).
%p AM/PM for 12-hour time.
%G GMT time zone indicator.
%z Time zone offset in relation to GMT (e.g. -0800).
%Z Time zone name.
%% A percent sign.

By default, all output is zero padded to two characters. For example, 02/03/2002.

A hyphen - between the % and the letter code instructs Lasso not to pad the output. For example, 2/3/2002

An underscore _ between the % and the letter instructs Lasso to pad the output with spaces. For example, 2/ 3/2002.


[Date_Format: 'Base Date',
-Format='Date Format']

[Date_Format: (Date),
-Format='Date Format']


Required Parameters
Base Date The date to be formatted in Lasso Date format.
-Format A string specifying how the date should be formatted.
Optional Parameters
Encoding Keyword Specifies the encoding for the tag's return value. Tags are encoded using -EncodeHTML by default if their value is output in a format file. No encoding is applied to nested tags unless an explicity encoding keyword is specified. One of -EncodeBreak, -EncodeHTML, -EncodeNone, -EncodeRaw, -EncodeSmart, -EncodeStrictURL, -EncodeURL, -EncodeXML.

Change Notes

The -DateFormat parameter changed to -Format in LDML 6.0. The %q format was added in 7.0.3.


To format a date for MySQL:

Use the [Date_Format] tag with an appropriate -Format parameter. The format for MySQL dates is yyyy-mm-dd, which is represented by the format parameter %Q . The following example converts the current date and time into MySQL date/time format.

[Date_Format: (Date), -Format='%Q']