Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can some please clarify how to convert the number of days between two dates into weeks?
We have date A and Date B. (01/01/2021 & 22/01/2021) that are 21 days apart. how do I convert the days into '3 weeks' in order to display the time taken into a Barchart as weeks?
Thanks
Try like this?
Floor(Fabs(Interval(Date#([date A], 'DD/MM/YYYY')-Date#([Date B],'DD/MM/YYYY'), 'DD'))/7) & ' Weeks' as WeekField