Hi, I'm building an app that needs to retrieve records from a SQL Server table based on a record's date.
The date values in the table are in the format of m/d/y h:m:s AM/PM (8/4/2003 1:02:16 PM). The tool I'm building allows the user to input a date range in the format of 08/04/2003 to 08/30/2003. So, for instance a record has the date value of 8/4/2003 1:02:16 PM. I want to pass in 08/01/2003 (date1) and 08/15/2003 (date2) and find that record. I've tried converting the date with ParseDateTime(), which didn't work and trying LIKE '%#date1#%' which didn't work either. Suggestions? The data in the table can't be changed, as it was generated by a tool already in production. Thanks, James ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137806 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
