imported>Aeric |
imported>Aeric Β |
(One intermediate revision 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]]
| |
| Β | |
| ==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 and Formula Functions ===
| |
| {{:Date/Time Strings}}
| |
| :''Learn more: [[Date and Time Formula Functions]]
| |
| Β | |
| ==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]]
| |