JohnJohnJohn
Posts: 10
|
Posted: 03/13/2014, 11:07 PM |
|
I have a database with separate date and time fields. The following works just fine in Access as a query,
WHERE CDate(SubmittedDate + SubmittedTime) BETWEEN #3/2/2014 8:00:00 PM# AND #3/3/2014 11:00:00 PM#
but when I try to set it up in the CCS Visual Query Builder I cannot get it to work. I have tried this,
WHERE (CDate(SubmittedDate + SubmittedTime) BETWEEN #{s_Start_Date s_Start_Time}# AND #{s_End_Date s_End_Time}#)
and this,
WHERE (CDate(SubmittedDate + SubmittedTime) BETWEEN #{s_Start_Date} {s_Start_Time}# AND #{s_End_Date} {s_End_Time}#)
but neither works.
Any ideas how to get this working?
|
|
|
|