imported>Aeric |
imported>Aeric |
| (28 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| Day, Date and Time-related [[Formula Functions]]. Learn more: [[#About Dates|About Dates]]
| | #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}}
| |
| | |
| ==About Dates==
| |
| 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.
| |
| | |
| 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.
| |
| | |
| 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]]
| |
