Date/Time Strings

From AgileApps Support Wiki
Revision as of 23:33, 18 October 2013 by imported>Aeric

Date/Time strings are used as arguments in many of the Date and Time Formula Functions, and can also be returned as the result from those functions.

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)
part of day am
pm
A text string the identifies the part of day for a 12-hour clock.
For more information, see http://en.wikipedia.org/wiki/12-hour_clock
Note:
In Form fields, the string is determined by the user's locale. For example, "vorm." and "nachm." in Germany. But in Formula Fields, the value must be either "am" or "pm".

Warn.png

Important: When coding a date in a Formula, always use the DATE and TIME functions. For example: DATE(2013,3,26). A date/time string like '3/26/2013' will work for some users, but fail for others.