1 of 1 people found this helpful
You can also use DATEPART("format", [Your date])
Format can be: year/quarter/month/day/week etc.. format is case sensitive.
Let us know if this help.
Please find the below attachment,if it is working then marked as correct or helpful.
Amar D. Savale
Book1_v10.2.twbx(3).twbx 2.1 MB