dates and SQL Server expects ODBC dates.
Doug
Eric Creese wrote:
>I am using the following to retreive records from a database. However I am not gettign any records and I should. Database is Access but will be moving to SQL for production
>
><cfset today365 = Now() +365>
><cfset today1 = Now() -1>
><cfquery name="getschedule" datasource="liberty">
> SELECT EVENT_ID,EVENT_DATE,EVENT_NAME,EVENT_TIME,EVENT_LOC
> FROM schedule
> WHERE EVENT_DATE <= #DATEFORMAT(today365, "MM/DD/YYYY")#
> AND EVENT_DATE > #DATEFORMAT(today1, "MM/DD/YYYY")#
> AND display='yes'
> ORDER BY EVENT_DATE;
></cfquery>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
