DATEPART

From AgileApps Support Wiki
Revision as of 18:40, 4 November 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The DATEPART function used with the DATE function to extract the date.

Syntax
DATEPART('dString'))
Return
A date in the format defined by Date Format
Examples
DATEPART('04/22/2009 03:15 am') ='04/22/2009'

DATEPART(DATE ('2009', '04', '22', '03', '15',  '00')) ='04/22/2009'