Home > database >  With the current time, how to get the next week on the last day of the time?
With the current time, how to get the next week on the last day of the time?

Time:09-19

With the current time, how to get the next week on the last day of the time?

CodePudding user response:

The first day of the week
(1) Sunday is the first day
RelativeDate (today (), 2-1 - (1 - sign (daynumber (today ())) + 1-1) * 7 - daynumber (today ())
(2) on Monday for the first day
RelativeDate (today (), 2-0 - (1 - sign (daynumber (today ())) + 0-1) * 7 - daynumber (today ())

The last day of the next week, is the first day of the week + 13 days

CodePudding user response:

Relativedate (today (), 2 + daynumber (today ()))

CodePudding user response:

Relativedate (today (), 15 - daynumber (today ()))

CodePudding user response:

CodePudding user response:

CodePudding user response:

CodePudding user response:

To calculate the current time from the last day of the week and a few days, then can be combined with seven days,

CodePudding user response:

Relativedate (today (), 2 + daynumber (today ()))
  • Related