Difference between revisions of "Date String"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
(Redirected page to Date/Time Strings)
Β 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
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.
#REDIRECT [[Date/Time Strings]]
Β 
'''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:
Β 
{| border="1" cellpadding="5" cellspacing="0"
!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
|}

Latest revision as of 20:07, 18 October 2013

Redirect to: