Reply To: Changing the date format the <CDATE> template metacomm

Product Compare Forums Multi-Edit Support Changing the date format the <CDATE> template metacomm Reply To: Changing the date format the <CDATE> template metacomm

#5372
Clay Martin
Keymaster

I did a search on CDATE in the help file, here is what I found:

Substitutes the current date. The <CDate> Metacommands allow for passing an optional format string. To specify a format string, use the following format.

<CDate format string>

Examples:

<CDATE dd’-‘MMM’-‘yy> would insert the date as 27-Jan-99

See table below for all of the valid format string values.

Format String
Function

d
Day of month as digits with no leading zero for single-digit days.

dd
Day of month as digits with leading zero for single-digit days

ddd
Day of week as a three-letter abbreviation. The function uses the LOCALE_SABBREVDAYNAME value associated with the specified locale.

dddd
Day of week as its full name. The function uses the LOCALE_SDAYNAME value associated with the specified locale.

M
Month as digits with no leading zero for single-digit months.

MM
Month as digits with leading zero for single-digit months.

MMM
Month as a three-letter abbreviation. The function uses the LOCALE_SABBREVMONTHNAME value associated with the specified locale.

MMMM
Month as its full name. The function uses the LOCALE_SMONTHNAME value associated with the specified locale.

y
Year as last two digits, but with no leading zero for years less than 10.

yy
Year as last two digits, but with leading zero for years less than 10.

yyyy
Year represented by full four digits

gg
Period/era string. The function uses the CAL_SERASTRING value associated with the specified locale. This element is ignored if the date to be formatted does not have an associated era or period string.

h
Hours with no leading zero for single-digit hours; 12-hour clock

hh
Hours with leading zero for single-digit hours; 12-hour clock

H
Hours with no leading zero for single-digit hours; 24-hour clock

HH
Hours with leading zero for single-digit hours; 24-hour clock

m
Minutes with no leading zero for single-digit minutes

mm
Minutes with leading zero for single-digit minutes

s
Seconds with no leading zero for single-digit seconds

ss
Seconds with leading zero for single-digit seconds

T
One character time marker string, such as A or P

tt
Multicharacter time marker string, such as AM or PM

HTH,
Clay