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!