Date conversion

[Luben]

hello friends how can i convert 14/08/2020 into month weeks year and quarter 

Thanks

[Vegar · Accepted solution]

Assuming your value is found within a field named [Date field]. 

Month(date#([Date field], 'MM/DD/YYYY'))

Week(date#([Date field], 'MM/DD/YYYY'))

Year(date#([Date field], 'MM/DD/YYYY'))

  'Q' & Ceil(Month(DateNumdate#([Date field], 'MM/DD/YYYY')/3)