Comparing Dates 1

[HowardMarks]

Hi guys, this is probably pretty simple but i can't work it out...

I have an access database with a list of products, with normal and promotional prices. The products also contain start and end dates for being on promotion.

I am displaying the products from the database in a table and need to work out whether each specific product is within its promotion dates, and if so highlight it.

I guess its something to do with the datediff function but i can't figure out precisely how to get this result...

Any help would be vastly appreciated. Nick (Web Designer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

 

[FesterSXS]

something like this might be ok for you

<%
While NOT objRecordset.EOF
  If ((objRecordset(&quot;FirstDate&quot;) <= Now) AND (objRecordset(&quot;LastDate&quot;) >= Now)) Then
    'highlighted version here
  Else
    'normal version here
  End If

  objRecordset.MoveNext
Wend
%>

Tony

http://www.phoenix-paints.co.uk/portfolio

 

[HowardMarks]

Thanks Fester that worked a treat Nick (Web Designer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

 

[FesterSXS]

always a pleasure Tony

http://www.phoenix-paints.co.uk/portfolio