between dates query

[derwent]

I have a DB with displayfrom and displayto date fields. I need to return the data if todays date is between the from and to dates, i.e. only when it should be displayed on the website.

Can someone help with the sql, I'm trying to gather something like

select * from mytable where vartodaysdate between displayfrom and displayto

 

[derwent]

just to add, I am setting the date to be UK and setting shortdate

<%
session.lcid=2057
vartodaysdate = (FormatDateTime(date(),vbshortdate))
%>

to output 24/04/2006 as this is the format of the dates in the MSSQL DB.

So if the DB has a record with displayfrom as 20/04/2006 and displayto as 30/04/2006 it will out put those records only.

Thanks