Difference between revisions of "Date String"

Revision as of 19:49, 18 October 2013

Date/Time strings are used as arguments in Date/Time Formula Functions, and can also be the result of applying a Date/Time formula function.

Examples

'03/27/2009 10:15 am'
'20.04.2009 10:45 pm' 
'2009-20-04 20:30'

Date/Time strings are composed of these elements:

Element	Syntax	Description
year	yyyy	A text string depicting the year (1900 - 9999)
month	mm	A text string depicting the month (1-12, beginning with January)
day	dd	A text string depicting the day of the month (1-31, depending on the number of days in the month)
hour	hh	A text string depicting the hour in the format (0-12 for a 12-hour clock, or 0-24 for a 24-hour clock)
minute	mm	A text string depicting the minute in the format (0-59)
am pm	a p	A text string depicting am/pm in a 12-hour clock day For more information, see http://en.wikipedia.org/wiki/12-hour_clock

@@ Line 20: / Line 20: @@
 |day||dd||A text string depicting the day of the month (1-31, depending on the number of days in the month)
 |-
-|hour||hh||A text string depicting the hour in the format (0-12 for a 12-hour clock day, or 0-24 for a 24-hour clock day)
+|hour||hh||A text string depicting the hour in the format (0-12 for a 12-hour clock, or 0-24 for a 24-hour clock)
 |-
 |minute||mm||A text string depicting the minute in the format (0-59)