AnsweredAssumed Answered

Working with dates

Question asked by sherrera on Nov 26, 2013
Latest reply on Nov 26, 2013 by philmodjunk


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?