calculation of the week

[Gabriel2020]

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?

[ArjenEX]

Hi @Gabriel2020

If you use the locale en_GB it should be fine.

[Gabriel2020]

Using the PT BR or US location does not work like this.

[Gabriel2020]

I would like it to be calculated from Monday to Sunday and it is being calculated from Monday to Saturday

[ArjenEX]

Yes, so use a locale which actually does make that calculation which is shown in my example

[iCFO]

Very cool trick. I didn’t know that different Localizations carried different definitions of week starting and ending days.