I have a table with 3 dates. DateSubmitted, DateRequired, DateCompleted. A user submits something he requests be done at a certain date (DateSubmitted), it should be finished at a certain date (DateRequired), and the last one when it was actually finished (DateCompleted).
How do I select everything that has been completed the last week, last month? Or everything that has been submitted last week, last month?
Grateful for help,
Billy
