Forums

This topic is locked

Date result data - Tricky?

Posted 28 Feb 2001 16:47:46
1
has voted
28 Feb 2001 16:47:46 Phil Cue posted:
Hi don’t know if you can help, but here goes...

I want to pull product data from a database to a results page, however this result data needs to be split using the date data (probably by 2 recordsets) to show result for latest products 30 days or earlier and then another for 31-90 days. How can I display product data so it displays 30 days or earlier and then another for 31-90 days when date data is, for example 01.03.01, 12.02.01, etc?!

Visualise it: From a search for Products a results page shows two tables with results as 1. Products up to 30 days old and 2. 31-90 old.

Please let me know if you know!! Thanks.

If you start haemorrhaging you're think too hard...!

Reply to this topic