The formulas for extracting Months and Year from a date field in saved searches TO_CHAR({datecreated},’MONTH’) – displays month name (Character) as result. Ex: Aprilinstead of ‘Month’ we can specify the format in which the month should be displayed.MON – Jan, Feb, etcMM – a numeric month from 1 to 12 TO_CHAR({datecreated},’YYYY’) – displays year in… Continue reading Extract Month and Year from Date field