Re: Date time format

[tony smith]

That worked how can I get the time out of the variable that is what is making it not receiving.  The time part of the variable is messing it up.

<CFQUERY NAME="GetResultsATL" DATASOURCE="ATLDBConnector">
SELECT prDateSubmitted, COUNT_PAGES_RECEIVED, COUNT_PAGES_SENT
FROM DBConnTable
WHERE prDateSubmitted = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#Dateformat(Now(),'MM/DD/YYYY')#">
</CFQUERY>

---

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

---