About week calculation

  • Resolved klingbeil

    (@klingbeil)


    3 years ago

    Hello,
    1) Now we calculate the week of a date. So, how can we print the beginning of the week and the weekend date of this calculated date together with the day name?
    2) For example, we wrote the 5th week as number, can we do the opposite concept on which date it corresponds to the 5th week of the year?

    Thanks

    • This topic was modified 3 years ago by klingbeil.
Viewing 4 replies - 16 through 19 (of 19 total)
1 2
  • Plugin Author codepeople

    (@codepeople)

    3 years ago

    Hello @klingbeil

    I’m sorry, but with every new entry, you change the request.

    If you have a date and want to sum some days to it, you must use the DATETIMESUM operation.

    If you have two dates and want to get the number of days between, you must use the DATEDIFF operation.

    Ex. To get the date 145 days after today as a text with date format, the equation would be:

    GETDATETIMESTRING(DATETIMESUM(TODAY(), 'dd/mm/yyyy', 145, 'd'),'dd/mm/yyyy');

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    3 years ago

    I guess we don’t get along because of my bad English. Please don’t make me feel bad about this..
    I’m already doing these. But I guess I can’t explain my problem well..

    Let me try to explain as briefly as possible. “Today’s date corresponds to which day of the year” I can’t do that.

    23/05/2025 145. Day

    24/05/2025 146. Day

    We have today’s date, but how do we calculate which day it falls on?
    Thanks.

    Plugin Author codepeople

    (@codepeople)

    3 years ago

    Hello @klingbeil

    In this case, you must rest the first day of the year from now:

    DATEDIFF(NOW(), '01/01/'+YEAR(), 'dd/mm/yyyy', 'd')['days']+1

    Best regards.

    Thread Starter klingbeil

    (@klingbeil)

    3 years ago

    Thank you it is.

Viewing 4 replies - 16 through 19 (of 19 total)
1 2

The topic ‘About week calculation’ is closed to new replies.