Hello,
I have created sql table with 2 columns...one date&time and other is numeric. When i add date to date&time column in SQL it always adds time of "12:00:00 AM" automatically (this is sql default and cannot be changed).
So when i write my "Where" statement in the Handler it keeps failing because it compares the TIME...I have tried the following expressions:
"dtDateTime=" & SQLStr(DateStrUTC($Now))
"dtDateTime=" & SQLStr($Now)
"dtDateTime=" & (DateStrUTC($Now))
Can anyone help with which step i should be using?
thank you,
Bal