Thursday, May 30, 2019

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.

No comments:

Post a Comment