imported>Aeric |
imported>Aeric |
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| Day, Date and Time-related [[Formula Functions]].
| | #REDIRECT [[Dates and Times#Date/Time Formats]] |
| :''Learn more:'' [[#Date/Time Formats|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/Time Formats==
| |
| Dates are used throughout the platform, in Appointments, as Start/End Dates in Tasks, Expected Close Date, Estimated Start/End Date, Date Due, etc.
| |
| | |
| Default formats are specified in the [[Company Information]] section of the Setup area. Admins and Users can change the default selection for an individual in the [[User Settings]].
| |
| | |
| ===Date Format===
| |
| | |
| These Date Formats are available in the platform:
| |
| | |
| : <tt>mm/dd/yyyy dd/mm/yyyy yyyy/dd/mm yyyy/mm/dd</tt>
| |
| : <tt>mm-dd-yyyy dd-mm-yyyy yyyy-dd-mm yyyy-mm-dd</tt>
| |
| : <tt>mm.dd.yyyy dd.mm.yyyy yyyy.dd.mm yyyy.mm.dd</tt>
| |
| | |
| ;where:
| |
| :<tt>mm</tt> is "Month", <tt>dd</tt> is "Day", <tt>yyyy</tt> is Year
| |
| :and delimters are:
| |
| ::<tt>(/)</tt> slash, or stroke
| |
| ::<tt>(-)</tt> dash, or hyphen
| |
| ::<tt>(.)</tt> period, dot, or full stop
| |
| | |
| ===Time Format===
| |
| Users can choose a 12-hour clock with AM/PM, or a 24-hour clock.
| |
| | |
| Using a 12-hour format, '10:00 AM' is created with this syntax:
| |
| :{| border="0" class="tightrows"
| |
| | '''Format''' || '''Type''' || '''Examples'''
| |
| |-
| |
| |
| |
| <tt>hh:mm a<br>
| |
| a hh:mm<br>
| |
| HH:mm</tt>
| |
| |
| |
| 12-hour clock<br>
| |
| 12-hour clock<br>
| |
| 24-hour clock<br>
| |
| |
| |
| 3:30 AM, 3:30 PM<br>
| |
| AM 3:30, PM 3:30<br>
| |
| 3:30, 15:30
| |
| |}
| |
| | |
| ===Date/Time Strings===
| |
| {{:Date/Time Strings}}
| |
| | |
| ==For Developers==
| |
| | |
| ===Date Expressions===
| |
| :{| border="0" class="tightrows"
| |
| | 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]]
| |
