1 Reply Latest reply on Nov 26, 2013 4:41 PM by philmodjunk

    Working with dates

    sherrera

      Title

      Working with dates

      Post

           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?