4 Replies Latest reply: Oct 6, 2017 11:12 AM by Stefan Wühl RSS

    How can I check whether a month/day falls within a date range?

    Josephine Campbell

      Hello all,

       

      I have some data that looks like this:

       

       

      StudentIDDOBStartDateEndDateBirthday?
      3142108/11/196022/10/201728/10/2017
      4628716/08/200222/10/201728/10/2017
      5177128/09/200022/10/201728/10/2017
      5177603/11/200422/10/201704/11/2017Yes
      5185804/01/196111/10/201718/10/2017

       

      I'm trying to determine whether a student will have a birthday during their course so I need to check whether the month/day of the DOB will fall between the StartDate and EndDate (inclusive). What's the best way of doing this?