Notes
DAY(date
)
Returns the day of the month, a number between 1 and 31
Date__c=7/13/2022
DAY(Date__c)=13
MONTH(date
)
Returns the month, a number between 1 (January) and 12 (December)
Date__c=7/13/2022
MONTH(Date__c)=7
YEAR(date
)
Returns the year of a date, a number between 1900 and 9999
Date__c=7/13/2022
YEAR(Date__c)=2022