Forum Discussion

eWise's avatar
eWise
Icon for Helper II rankHelper II
5 years ago
Solved

Dateadd function to give a later date

Hi all,   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 ...
Need Help
  • eWise's avatar
    eWise
    5 years ago

    Thank you Fowmy It worked perfectly. 

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

eWise 

You can add the following calculated column to your table:

Adjusted DateTime = 

IF(
    WEEKDAY([DateTime]) = 7,
    INT([DateTime]) + 2 + TIME(9,0,0),
    [DateTime]
)

 

 

 

 

eWise's avatar
eWise
Icon for Helper II rankHelper II
5 years ago

Thank you Fowmy It worked perfectly.