Difference between revisions of "Date String"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
| 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)
| |
| |-
| |
| |part of day
| |
| |am<br>pm
| |
| |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
