Code for only showing data in a certain date interval 2

[movium]

Hi,

This is my QUERY today:

<CFQUERY NAME=&quot;Aktuellt&quot; DATASOURCE=&quot;movium&quot;>
SELECT * FROM UTBILDNING WHERE DATE_UTBILDNING < #DateAdd('D', 90, Now())#
ORDER BY DATE_UTBILDNING
</CFQUERY>

The query is supposed to pick courses that has todays date and 90 days forward. Strangely, older courses than Now () are also showing. What am I doing wrong here?

Regards

Niclas Östlund

 

[webmigit]

Try

SELECT *
FROM UTBILDNING
WHERE DATE_UTBILDNING < #DateAdd('D', 90, Now())#
AND NOT DATE_UTBILDNING <= #DateAdd('D', -1, Now())# [ Founder of <A href=&quot;

http://www.bibleclicks.com&quot;>Bibleclicks.com</A>,

online bible. ]

 

[tleish]

You could also try:

<CFQUERY NAME=&quot;Aktuellt&quot; DATASOURCE=&quot;movium&quot;>
SELECT * FROM UTBILDNING
WHERE DATE_UTBILDNING >= #CreateODBCDate(Now())#
AND DATE_UTBILDNING < #CreateODBCDate(DateAdd(&quot;d&quot;, 90, Now()))#
ORDER BY DATE_UTBILDNING
</CFQUERY> - tleish

 

[Guest_imported]

It's not strange; your query asks for all dates less than (older) than 90 days from today. Naturally, you will get dates older than Now(). Try this:

CFQUERY NAME=&quot;Aktuellt&quot; DATASOURCE=&quot;movium&quot;>
SELECT *
FROM UTBILDNING
WHERE DATE_UTBILDNING between #CreateODBCDate(Now())#
AND #CreateODBCDate(DateAdd(&quot;d&quot;, 90, Now()))#
ORDER BY DATE_UTBILDNING
</CFQUERY>