imported>Aeric |
imported>Aeric Β |
(25 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
| Day, Date and Time-related [[Formula Functions]]. Learn more: [[#Date Formats|Date Formats]]
| | #REDIRECT [[Dates and Times#Date/Time Formats]] |
| Β | |
| {| border="0" cellpadding="5" cellspacing="0" width="50%"
| |
| |-valign="top"
| |
| |
| |
| [[#DATE|DATE]]<br>
| |
| Β | |
| [[#DATEADD|DATEADD]]<br>
| |
| Β | |
| [[#DATECOMP|DATECOMP]]<br>
| |
| Β | |
| [[#DATEPART|DATEPART]]<br>
| |
| Β | |
| [[#DATESUB|DATESUB]]<br>
| |
| Β | |
| [[#DATEVALUE|DATEVALUE]]
| |
| Β | |
| [[#DAY|DAY]]<br>
| |
| Β | |
| |
| |
| [[#HOUR|HOUR]]<br>
| |
| Β | |
| [[#MINUTE|MINUTE]]<br>
| |
| Β | |
| [[#MONTH|MONTH]]<br> | |
| Β | |
| [[#NOW|NOW]]<br>
| |
| Β | |
| [[#NULLDATE|NULLDATE]]<br>
| |
| Β | |
| [[#NULLTIME|NULLTIME]]<br>
| |
| Β | |
| [[#SECOND|SECOND]]<br>
| |
| Β | |
| |
| |
| [[#TIME|TIME]]<br>
| |
| Β | |
| [[#TIMEPART|TIMEPART]]<br>
| |
| Β | |
| [[#TIMEVALUE|TIMEVALUE]]<br>
| |
| Β | |
| [[#TODAY|TODAY]]<br>
| |
| Β | |
| [[#WEEKDAY|WEEKDAY]]<br>
| |
| Β | |
| [[#YEAR|YEAR]]<br>
| |
| |}
| |
| Β | |
| ==Day, Date and Time-related Formula Functions==
| |
| Β | |
| ===DATE===
| |
| {{:DATE}}
| |
| Β | |
| ===DATEADD===
| |
| {{:DATEADD}}
| |
| Β | |
| ===DATECOMP===
| |
| {{:DATECOMP}}
| |
| Β | |
| ===DATEPART===
| |
| {{:DATEPART}}
| |
| Β | |
| ===DATESUB===
| |
| {{:DATESUB}}
| |
| Β | |
| ===DATEVALUE===
| |
| {{:DATEVALUE}}
| |
| Β | |
| ===DAY===
| |
| {{:DAY}}
| |
| Β | |
| ===HOUR===
| |
| {{:HOUR}}
| |
| Β | |
| ===MINUTE===
| |
| {{:MINUTE}}
| |
| Β | |
| ===MONTH===
| |
| {{:MONTH}}
| |
| Β | |
| ===NOW===
| |
| {{:NOW}}
| |
| Β | |
| ===NULLDATE===
| |
| {{:NULLDATE}}
| |
| Β | |
| ===NULLTIME===
| |
| {{:NULLTIME}}
| |
| Β | |
| ===SECOND===
| |
| {{:SECOND}}
| |
| Β | |
| ===TIME===
| |
| {{:TIME}}
| |
| Β | |
| ===TIMEPART===
| |
| {{:TIMEPART}}
| |
| Β | |
| ===TIMEVALUE===
| |
| {{:TIMEVALUE}}
| |
| Β | |
| ===TODAY===
| |
| {{:TODAY}}
| |
| Β | |
| ===WEEKDAY===
| |
| {{:WEEKDAY}}
| |
| Β | |
| ===YEAR===
| |
| {{:YEAR}}
| |
| Β | |
| ==Date Formats==
| |
| Dates are used throughout the platform, in Appointments, as Start/End Dates in Tasks and Projects, Expected Close Date, Estimated Start/End Date, Date Due, etc. | |
| Β | |
| ===Default Date Format===
| |
| The dates in records are formatted according to the default date format specified in [[Personalize]] and [[Company Information]] section of the Setup area. Depending on your geographic location, users and organizations may prefer to have dates presented as 20.04.2009, or 04/20/2009.Β
| |
| Β | |
| {{Note|Date formats are ''case-sensitive''.}}
| |
| Β | |
| These Date Formats are available in the platform:
| |
| Β | |
| :::{| border="0" cellpadding="5" cellspacing="5"
| |
| |-valign="top"
| |
| | <tt>mm/dd/yyyy</tt> || <tt>dd/mm/yyyy</tt> || <tt>yyyy/dd/mm</tt> || <tt>yyyy/mm/dd</tt>
| |
| |-
| |
| | <tt>mm-dd-yyyy</tt> || <tt>dd-mm-yyyy</tt> || <tt>yyyy-dd-mm</tt> || <tt>yyyy-mm-dd</tt>
| |
| |-
| |
| | <tt>mm.dd.yyyy</tt> || <tt>dd.mm.yyyy</tt> || <tt>yyyy.dd.mm</tt> || <tt>yyyy.mm.dd</tt>
| |
| |}
| |
| Β | |
| ::;Where:
| |
| :::{| border="0" cellpadding="5" cellspacing="0"
| |
| |-
| |
| ::<tt>mm</tt> is "Month"
| |
| ::<tt>dd</tt> is "State"
| |
| ::<tt>yyyy</tt> is Year
| |
| |}
| |
| Β | |
| ;Delimiters in Date Strings:
| |
| :::{| border="0" cellpadding="5" cellspacing="0"
| |
| |-
| |
| ;Date Delimiters:
| |
| ::<tt>(/)</tt> slash, or stroke
| |
| ::<tt>(-)</tt> dash, or hyphen
| |
| ::<tt>(.)</tt> period, dot, or full stop
| |
| |
| |
| ;Time Delimiter:
| |
| Β | |
| ::<tt>(:)Β Colon</tt>
| |
| |}
| |
| Β | |
| ===Date and Time Format===
| |
| Depending on the location, users can choose a 12-hour clock day (with AM/PM), or a 24-hour clock day.
| |
| Β | |
| {{Note|Date/Time formats are ''case-sensitive''.}}
| |
| Β | |
| Using a 12-hour format, '10:00 AM' is created with this syntax:
| |
| hh:mm am
| |
| Β | |
| Using a 24-hour format, 16:15 hours (4:15 PM) is created with this syntax:
| |
| hh:mm
| |
| Β | |
| Several examples are shown here:
| |
|
| |
| 12-hour clock day
| |
|
| |
| Β Β Date/Time FormatΒ Β Β Β Syntax
| |
| Β Β ---------------------Β Β ------------------
| |
| Β Β '06/12/2009 10:15 am'Β Β mm/dd/yyyy hh:mm am
| |
| Β Β '06-12-2009 12:15 pm'Β Β mm-dd-yyyy hh:mm pm
| |
| Β Β '06.12.2009 05:37 pm'Β Β mm.dd.yyyy hh:mm pm
| |
|
| |
| 24-hour clock day
| |
| Β
| |
| Β Β Date/Time FormatΒ Β Β Β Syntax
| |
| Β Β ------------------Β Β Β ------------------
| |
| Β Β '06/12/2009 10:15'Β Β Β mm/dd/yyyy hh:mm
| |
| Β Β '06-12-2009 12:15'Β Β Β mm-dd-yyyy hh:mm
| |
| Β Β '06.12.2009 17:37'Β Β Β mm.dd.yyyy hh:mm
| |
| Β | |
| ===Date/Time String===
| |
| {{:Date String}}
| |
| Β | |
| ==For Developers==
| |
| Β | |
| ===Date Expressions===
| |
| :{| border="0" cellpadding="5" cellspacing="0"
| |
| !width="375"|Expression
| |
| !Result
| |
| |-valign="top"
| |
| |<tt>DATESUB('06/13/2009', 2, 'MONTH')</tt>
| |
| | <tt>= '04/13/2009'</tt>
| |
| |-valign="top"
| |
| |<tt>DATESUB(end_date, MONTH(start_date), 'MONTH')</tt>
| |
| | <tt>= '04/23/2009'</tt>
| |
| |-valign="top"
| |
| |<tt>DATESUB(end_date, start_date)</tt>
| |
| | <tt>= 140</tt> (days)
| |
| |-valign="top"
| |
| |<tt>MONTH(end_date) - MONTH(start_date)</tt>
| |
| | <tt>= 4</tt> (months)
| |
| |}
| |
| Β | |
| Where:
| |
| :<tt>end_dateΒ = '06/23/2009'</tt>
| |
| :<tt>start_date = '02/03/2009'</tt> and <tt>MONTH(start_date) = 2</tt>
| |
| Β | |
| ===Long Date Format===
| |
| {{:Long Date Format}}
| |
| Β | |
| Β | |
| [[Category:Glossary]]
| |