Forum Discussion

Marco Verace's avatar
Marco Verace
Copper Contributor
May 30, 2018
Solved

Find missing days within a Range

Hi guys!
I would need to know if some days are missing, see the example below please.

I have a range of days like this : 
01JAN19 - 20JAN19
24JAN19 - 30JAN19

I'd like to get an output of the missing days:

  • 21JAN19
  • 22JAN19
  • 23JAN19
  • 31JAN19



Do you have any advice on how to build it?
Thank you very much in advance for the help

8 Replies

    • Marco Verace's avatar
      Marco Verace
      Copper Contributor

      I have two ranges each time, but different example to analyse.

       

      Thanks,

      Marco

  • Jamil's avatar
    Jamil
    Bronze Contributor

    Your logic does not seem to be correct.

     

    your range does not have 31 Jan 2019 then why to list 31JAN19 in the missing dates?

    • Marco Verace's avatar
      Marco Verace
      Copper Contributor

      Hi Mohammad, thanks for the reply.

      Apologises if I did not express my self properly.

       

      As 31JAN19 does exist in reality, I would consider it as a missing date considering the data I have been provided.

       

      Edit: Exactly as Sergei said

       

Resources