DATEPART
From AgileApps Support Wiki
Revision as of 21:38, 8 February 2012 by imported>Aeric
The DATEPART function returns a DATE value that is normalized to the start of the day, for use in comparisons.
To get a string that contains the date only, use:
TEXT(MONTH(date_modified))+'/'+TEXT(DAY(date_modified))+'/'+TEXT(YEAR(date_modified))
- Syntax
DATEPART('dString'))
- Return
- A date in the format defined by Date Format
- Examples
DATEPART('04/22/2009 03:15 am') ='04/22/2009 12:00:00 AM'
DATEPART(DATE ('2009', '04', '22', '03', '15', '00')) ='04/22/2009 12:00:00 AM'