The date format of the specified Date. You can use one of the following options:
AUTNDATE
#ISODATETIME (for details, see DateFormatCSVs)a string that contains one or more of the date formats in the following table.
YY
|
Year (two digits). For example, 99, 00, 01, and so on. |
YYYY
|
Year (four digits). For example, 1999, 2000, 2001, and so on. |
#YY+
|
Year (two or four digits). If you provide two digits, it uses the For example, it interprets |
#Y
|
Year (one to a maximum of 16 digits), optionally followed by AD or BC. An apostrophe (') immediately before the year denotes a truncated year. For example, 2008, '97 (interpreted as 1997), 97 (interpreted as 97 AD), '08 (interpreted as 2008), 2008 AD, and 200 BC. A truncated year with a BC identifier is not valid ('08 BC). |
#FULLYEAR
|
Year (one to a maximum of 16 digits). For example, 8, 98, 108, 2008, each of which is taken literally. The year is taken relative to the common EPOCH (0 AD). |
#ADBC
|
Time period. For example, The only exception to this is when you use both Micro Focus recommends that you use only |
LONGMONTH
|
A long month, for example, January, February, and so on. |
SHORTMONTH
|
A short month, for example, Jan, Feb, and so on. |
MM
|
Month (two digits). For example, 01, 10, 12, and so on. |
M+
|
Month (one or two digits). For example, 1,2,3,10, and so on. |
DD
|
Day (two digits). For example, 01, 02, 03, 12, 23, and so on. |
D+
|
Day (one or two digits). For example, 1, 2, 12, 13, 31, and so on. |
LONGDAY
|
Two digits with a postfix. For example, 1st, 2nd, and so on. |
HH
|
Hour (two digits). For example, 01, 12, 13, and so on. |
H+
|
Hour (one or two digits). |
NN
|
Minute (two digits). |
N+
|
Minute (one or two digits). |
SS
|
Second (two digits). |
S+
|
Second (one or two digits). |
ZZZ
|
Time zone, for example, GMT, EST, PST, and so on. |
ZZZZZ
|
Time difference (one to nine digits). For example, +04 denotes four hours ahead of UTC. Other examples include +4, +04, +0400, +0400 MSD (the string MSD is ignored). A further example is +030. In this case the time difference is interpreted as 30 minutes. This option accepts a single Z character in a date string as UTC. It accepts time zones between -1300 and +1500. |
#PM
|
An AM or PM indicator (two characters). For example, 2001/09/09 02:46:40 PM. |
#S
|
A space. |
| Actions: | DateConvert |
| Type: | String |
| Default: | |
| Example: | action=DateConvert&Date=10/05/1234&DateFormat=DD/MM/YYYY
|
| See Also: | Date
DateFormatCSVs |
|
|