View source for Date

Day, Date and Time-related [[Formula Functions]]. Learn more: [[#Date Formats|Date 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 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]]