Date time format

[tony]

I am having a hard time converting a text string date to a Datetime comparing I have try ParseDateTime and LSParseDatetime.  

here is the code prDateSubmitted is the date that in the database is a text field.  Need to convert to date to compare dates to my selection.

<CFQuery name="GetResultsATL" DATASOURCE="ATLDBConnector">
SELECT prDateSubmitted, COUNT_PAGES_RECEIVED, COUNT_PAGES_SENT
FROM DBConnTable
WHERE #DateFormat(Now())# = #ParseDateTime(prDateSubmitted)#

Any help would be great

Thanks

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---