Re: date and time from two different inputs query a single datetime field

2012-05-10 Thread Bobby
#createOBDCDateTime(form.xdate_use & ' ' & form.xtime)# On 5/10/12 9:50 PM, "Les Mizzell" wrote: > > ex: 05/31/2012 > ex: 3:31 PM > >Given the values used as examples for the fields above, exactly how >would I go about querying a datetime stamp field (SQL Server) to find >all records dates on

RE: date and time from two different inputs query a single datetime field

2012-05-10 Thread andy matthews
, 2012 8:50 PM To: cf-talk Subject: date and time from two different inputs query a single datetime field ex: 05/31/2012 ex: 3:31 PM Given the values used as examples for the fields above, exactly how would I go about querying a datetime stamp field (SQL Server) to find all records dates on or after

date and time from two different inputs query a single datetime field

2012-05-10 Thread Les Mizzell
ex: 05/31/2012 ex: 3:31 PM Given the values used as examples for the fields above, exactly how would I go about querying a datetime stamp field (SQL Server) to find all records dates on or after the date/time above? No problem doing it with just the date: responsedate >= but for the