1 Reply Latest reply: Jul 7, 2017 10:52 AM by Dan Sullivan RSS

    6 Month forward from the Selected Date

    Salamon Musayev

      Hello,

       

      I need help in solving the following issue I am having.

       

      I have a table with the following fields.

      ID -  User ID  

      StartDate (The date of the first visit)

      StartMonthYear (The month and year of the first visit)

      VisitDate (Date of any visits that have occurred)

      VisitMonthYear (Month and Year if the visit)

       

      I need to create a flag, that will flag all the visits that have occurred in the 6 month post StartDate

      For example if a client first visit was on Jan 1st 2016, and he comes on the 1st of the month every month.  The flag will have the all the fields that are associated with his visits for the next 6 month which includes Jan 1st through June 1st 2016.

       

      Please help.

       

       

      Thank you,