date to the format of the date in your text field:
WHERE prDateSubmitted = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#Dateformat(Now(),'your mask here')#">
Pascal
> -----Original Message-----
> From: tony [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 26 maart 2004 15:43
> To: CF-Talk
> Subject: Date time format
>
> 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]
