AnsweredAssumed Answered

searching for dates

Question asked by Jacques on Apr 20, 2010
Latest reply on Apr 21, 2010 by comment_1

Title

searching for dates

Post

I have spend several days trying to come with a script to sort out dates between a Start date and an End date. The Start date is set by the user, the End date is always Today.

 

The database has the following records:

money    date

$2000    aug 1 2009

$1200    apr 9 2009

$1100    feb 1 2010

$3000    sep 8 2009

$500      apr 1 2010

 

So a value of $2000 is active from aug 1 2009 til sep 8 2009

The date set by the user will be jan 1 2010, The report should have all dates between jan 1 2010 and today.

 

The end result should look like:

$3000    sep 8 2009

$1100    feb 1 2010

$500      apr 1 2010

 

As jan 1 2010 is inbetween sep 8 2009 and feb 1 2010 then sep 8 2009 should be included in the list.

 

Hope that soneone has an answer for me.

 

Regards,

Jacques

 

 

 

Outcomes