Good afternoon everyone, how are you?
In this calculation, the DAY of Weed should come as 7 but it is showing as 0.
The week should start on Monday and end on Sunday, 1 and 7.
@iCFO You helped me with this calculation in the past, can you help me?
If you use the locale en_GB it should be fine.
Using the PT BR or US location does not work like this.
I would like it to be calculated from Monday to Sunday and it is being calculated from Monday to Saturday
Yes, so use a locale which actually does make that calculation which is shown in my example
Very cool trick. I didn’t know that different Localizations carried different definitions of week starting and ending days.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.