Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
use
date(floor(weekend(yourdate,0,2)))
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.