Date Format Strings

Purpose	The date format strings are used to convert and format a date as a string using the format calculation function.
Format
	%a	abbreviated weekday name
	%A	full weekday name
	%b	abbreviated month name
	%B	full month name
	%c	date and time representation appropriate for locale
	%d	day of month
	%H	hour in 24-hour format
	%I	hour in 12-hour format
	%j	day of year
	%m	month as number
	%M	minute
	%p	current locale's AM/PM indicator
	%S	second
	%U	number of week of year (with Sunday as first day of week)
	%w	number of weekday (Sunday = 0)
	%W	number of week of year (with Monday as first day of week)
	%x	date representation of current locale
	%X	time representation of current locale
	%y	year without century
	%Y	year with century
	%z or %Z	time-zone name/abbreviation
	%%	percent sign

Numerical Format Strings

Purpose	The numerical format strings are used to convert and format a number as a string using the format calculation function.
Format
	999,999	eliminates any numbers after the decimal point and specifies a six digit number with a single comma after the thousands column
	999,999.99	eliminates any numbers after two places after the decimal point and specifies an eight digit number with a single comma after the thousands column
	999999	eliminates any numbers after the decimal point and specifies a six digit number
	999999.99	eliminates any numbers after two places after the decimal point and specifies an eight digit number