Hello all,
I'm currently using the following equation to calculate the Week Num based on create dates:
tonumber(datetimeformat([shipment_create_dt],"%W"))+1
The equation is working correctly, the only issue I'm having is that the equation considers a week Monday to Sunday. I'm trying to find a way for the formula to consider a week Sunday to Saturday, as this is the procedure in which my account reports weekly metrics.
As an example, the formula I'm currently using is considering 1/12/20 as week 2 while I would like it to be considered as week 3.
I have searched the community and I haven't been able to find an answer, sorry if this has been answered previously.
Thank you.
