Dateadd function to give a later date

Question

Hi all,&nbsp;I have a datetime column and I need an adjusted datetime column where if an entry falls on a saturday, the adjusted datetime goes to the following Monday 9 a.m. else the datetime remains remains unchanged like below.&nbsp;&nbsp;DayOfWeekDateTimeAdjustedDateTimeSat4/10/2021 11:004/12/2021 9:00Mon3/29/2021 9:203/29/2021 9:20&nbsp;Thanks for the help.&nbsp;

ewise · Accepted Answer

Thank you&nbsp;Fowmy&nbsp;It worked perfectly.&nbsp;&nbsp;

Forum Discussion

Dateadd function to give a later date

2 Replies

Related content

DATEADD function

DATEADD Function

DATEADD Function

Function Dateadd problem

Help with DATEADD function

DayOfWeek	DateTime	AdjustedDateTime
Sat	4/10/2021 11:00	4/12/2021 9:00
Mon	3/29/2021 9:20	3/29/2021 9:20