8,849
edits
Changes
→Using sscalculation to Change Date Formats of Data in Custom Fields
|%c||will return the month number in short format, e.g. ''9'' for September
|-
|%hd||will return hour, e.g. the numeric day of month (''1201-31'')
|-
|%e||will return the numeric day of month (''1-31'')|-|%h||will return hour (''01-12'')|-|%i||will return minutes, e.g. (''00-59'')|-|%k||will return hour (''0-23'')
|-
|%m||will return the month number, e.g. ''09'' for September
|%p||will return AM/PM information, e.g. ''AM''
|-
|%r||will return the full time in 12-hour format, e.g. ''12:00:00 AM''|-|%s||will return seconds (''00-59'')
|-
|%y||will return the truncated year, e.g. ''12'' for 2012
|-
|%D||will return the month ordinal, e.g. ''30th''
|-
|%H||will return hour (''00-23'')
|-
|%M||will return the month name, e.g. ''September''
|-
|%T||will return the full time in 24-hour format, e.g. ''23:00:00''
|-
|%W||will return the day of the week, e.g. ''Sunday''
|-
|%Y||will return the four-digit year, e.g. ''2013''
|}
