Working with dates
I have a database containing numerous dates. Report Date, Date due to A and Date due to Z
A is calculated to be 60 days after Report Date
Z is calculated to be 1 year from Report Date
I need to be able to generate a weekly report that lists the records that are due in 30 days, 21 days, 14 days and 7 days.(for both the Due to A and Due to Z).
Having a little trouble wrapping my head around using the Get(CurrentDate) and a 22-30 days, and for the other ranges,
What do you suggest?