DateTime Formatting

Some Axcis programs provide DateTime formatting and the Formatting string can either be set using Microsoft .NET conventions or LCDSmartie convensions.  The Formatting string can comprise a mixture of ordinary characters (that are passed unchanged to the result string), and data formatting characters.

The .NET convensions are documented by Microsoft and use mixed case characters for the following categories:

Alternatively, the following  formatting character strings can be used in the LCDSmartie convension Formatting string (all lower case):
 

yy  = Year last 2 digits
yyyy  = Year as 4 digits
m  = Month number no-leading 0
mm  = Month number as 2 digits
mmm  = Month using ShortDayNames (Jan)
mmmm  = Month using LongDayNames (January)
d  = Day number no-leading 0
dd  = Day number as 2 digits
ddd  = Day using ShortDayNames (Sun)
dddd  = Day using LongDayNames  (Sunday)
ddddd  = Day in ShortDateFormat
dddddd  = Day in LongDateFormat
 
c  = Use ShortDateFormat + LongTimeFormat
h  = Hour number no-leading 0
hh  = Hour number as 2 digits
n = Minute number no-leading 0
nn  = Minute number as 2 digits
s  = Second number no-leading 0
ss  = Second number as 2 digits
zzz  = Milli-sec number as 3 digits
t  = Use ShortTimeFormat
tt  = Use LongTimeFormat
 
am/pm  = Use after h : gives 12 hours + am/pm
a/p  = Use after h : gives 12 hours + a/p
ampm  = As am/pm
Parts of this page are courtesy Neil Moffatt and LCDSmarty.