>
> 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
You cannot run ColdFusion functions in the database engine
What database engine are you using? Each should have it's own date
functions to convert strings to date
E.g. SQL Server you can use Convert(DateTime, prDateSubmitted)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
