2 Replies Latest reply: Sep 26, 2017 10:02 AM by Martin Pallesen RSS

    Checking for previous occurrences within 30 days

    Martin Pallesen

      Hi all,

       

      This is my challenge (simplified):

      I have an ID field and a Date field.

      For each row I need to check if there is at least 1 occurrence with the same ID within 30 days and flag this with a '1' in a new field called 'Repetition'.

       

      ID    DATE              REPETITION

      A     2017-15-08    

      A     2017-16-08     1

      A     2017-20-08     1

      A     2017-30-09

      A     2017-19-10     1

       

      How can I achieve this?

       

      Thanks in advance!