Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to create an intervalmatch that deals with dates. The issue I am coming across is that one of my ranges is 12/21 (dec 21) to 1/20 (Jan 20). So any data that falls into this date range results in a null. How can I indicate that following Dec comes Jan?
Hi,
try adding information about the year to your interval - the numeric value (the sum of days from some date in the past) should then pick it up and you should be fine.
HTH
try creating a calender table and then use your date with year into consideration.
Regards
S