PM Date column Datetime + 4 hours

[desmond_lee]

Hi Experts

I just really not good in doing datetime expression. I want to add a 4 hours duration to the timedate column PM Date. And I see and error all the time. where have I done wrong

(DATETIME([PM DATE]) + "004:00:00") < DATETIME(NOW())

[Suvrutt_Gurjar · Accepted solution]

---

@desmond_lee wrote:

to the timedate column PM Date

---

Assuming the [PM DATE] column is DatetTime type column as you have written above , please try 

([PM DATE] + "004:00:00") < NOW()

Since both [PM DATE]  and NOW() are datetime values, you need not further wrap them with DATETIME()

[desmond_lee]

Thank very much