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

null
    • gold_cat
    • 3 wk ago
    • Reported - view
            '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?

      • Créateur de bien-être
      • Sebastien_Guillet
      • 3 wk ago
      • Reported - view

       Yes thank you very much

    • John_Halls
    • 2 wk ago
    • Reported - view

    This is the same as 

    'Start' := today() - weekday(today());
'End' := today() - weekday(today()) + 6;

    Regards John

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 2 wk agoLast active
  • 3Replies
  • 45Views
  • 3 Following