Week Ending Syntax

[#1]

I have a date field that needs to be converted to a week end date. The week ends on Tuesdays so the date should always convert to the following Tuesday unless the date is Tuesday itself then the value is fine.

How can this be setup in the load script? Thank you so much for the help!

[ramoncova06]

use

date(floor(weekend(yourdate,0,2)))

[Gysbert_Wassenaar · Accepted solution]

You can use the WeekEnd function. The third parameter can be used to specify an offset in case the last day of the week is not Sunday. So WeekEnd(MyDate, 0, 2) should do the trick.