Extract the Day, Month or Year from a Date or Date/Time Field

Users can use the following formulas to extract the day, month or year from a Date field or Date/Time field:

• To extract the day: EXTRACT(DAY FROM {datefield})
• To extract the month: EXTRACT(MONTH FROM {datefield})
• To extract the year: EXTRACT(YEAR FROM {datefield})

The formula extracts details from any date. Example: If today is 12/6/2013. The formula EXTRACT(DAY FROM {today}) will extract the day from the today's date and show "6" as result.