Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello friends how can i convert 14/08/2020 into month weeks year and quarter
Thanks
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)
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)