Hi there everyone,

 

My client suddenly dropped on me that they need to be able to search by
date, IE: the past 1 day, 3 days, 5 days or 7 days.  In the DB, the date
format is: 2001-07-05 (For example) but I have no clue how to count the days
in between to know how many days I am counting.  Say they have something at
the end of feb and it runs into march, I have no clue how to work this out.

 

Could anyone show me an example of how to do this?  So to take 2001-07-05
and add 3 days to it?  So if they choose 3 days, it would have to be CURRENT
DATE + 2 I guess, that way you would see all dates from CURRENT DATE OR date
= '2001-07-06' OR date = '2001-07-07'.

 

Any help really would be appreciated.

 

Chris

Reply via email to