0
Date of the first day of the current week
Hello,
I am looking for a solution that allows me to display the date of the first day of the current week in the 'Start' field as well as the date of the last day of the current week in the 'End' field.
You just have to take into account that the first day is always Monday and the last day is always Sunday.
For example for this week, the 'Start' field should display "Monday, December 30, 2024" and the 'End' field should display "Sunday, January 5, 2025".
Thank you for your help.
3 replies
-
'Start' := date(year(today()), month(today()), day(today()) - weekday(today())); 'End' := date(year(today()), month(today()), day(today()) - weekday(today()) + 6)
Does that solve the problem?
-
This is the same as
'Start' := today() - weekday(today()); 'End' := today() - weekday(today()) + 6;
Regards John
Content aside
- Status Answered
- 2 wk agoLast active
- 3Replies
- 45Views
-
3
Following