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.