Hello everybody,
today I want to describe some date time specifiers in acumatica.
d - is default format pattern, so if you intend to use short date pattern, you can just ommit pattern in usage function
public static System.Text.StringBuilder MakePattern(string format, System.Globalization.DateTimeFormatInfo df)
D - long date pattern. Something similar to "Thursday, April 10, 2008"
F - long time pattern. Full date/time pattern. Something similar to "Monday, June 15, 2009 1:45:30 PM".
G - long time pattern. General date time pattern. Something like "6/15/2009 1:45:30 PM" for "en-US" or "2009/6/15 13:45:30" for zh-CN
M equals to m and means Month day pattern "June 15"
R equals to r - RFC 1123 pattern. The custom format string is "ddd, dd MMM yyyy HH':'mm':'ss 'GMT' like "Mon, 15 Jun 2009 20:45:30 GMT"
T - long time pattern. "1:45:30"
U - long time pattern. Universal full date/time pattern. "Monday, June 15, 2009 8:45:30 PM" or "den 15 juni 2009 20:45:30" ( for sv-SE )
s - sortable date time pattern. Intended for sorting as strings. Format: "yyyy'-'MM'-'dd'T'HH':'mm':'ss". Looks like "2009-06-15T13:45:30"
t - short time pattern. 1:45 PM ( for en-US ), "13:45" ( hr-HR )
u - universal sortable date time pattern. 2009-06-15 20:45:30Z. Also for sorting as string.
y equals to Y year month pattern. Looks like June, 2009
f - short time pattern. Similar to "Monday, June 15, 2009 1:45 PM". Differs from 'F' by ommiting seconds
g - short time pattern ( at least in code ), and looks like this:
case 'g':
builder.Append(df.get_ShortDatePattern()).Append(' ').Append(df.get_ShortTimePattern());
return builder;
I was surprised because here g stands for "General date/time pattern" or "6/15/2009 1:45 PM" while in acumatica 'g' is equal to 'f'