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())
Solved! Go to 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 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()
Thank very much
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |