topic Re: WeekStart & WeekEnd in App Development

WeekStart & WeekEnd

SergioS — Sat, 16 Nov 2024 17:45:32 GMT

Why WeekStart('01/01/2020') returns 30/12/2019 and WeekEnd('31/12/2020') returns 03/01/2021 regardless the value of BrokenWeeks.

I'm expecting as results 01/01/2020 and 31/12/2020.

Thank you.

Re: WeekStart & WeekEnd

Taoufiq_Zarra — Wed, 02 Dec 2020 09:27:53 GMT

@SergioS Weekstarts or weekend corresponds to the week's beginning

This function returns a value corresponding to a timestamp of the first millisecond of the first day (Monday) of the calendar week containing date

do you need MonthStart and MonthsEnd ?

Re: WeekStart & WeekEnd

SergioS — Wed, 02 Dec 2020 13:54:20 GMT

Hi Taoufiq, I am looking for a formula for weeks, not months. For every year YYYY it must return 1/1/YYYY for the first week, and 31/12/YYYY for the last week. Thank you.