Hi. I am trying to insert missing dates between 31st Decemeber 2021 till 31st July 2023 when there is no inventory noted on that day. For eg: If Plant Y352 has inventory only on 1st jan and 3rd jan then it should insert a row with missing dates and copy the same information for Y352 for 31st Dec 2021 and 2nd Jan with Inventory as 0 . Attaching an excel with expected input and output
Solved! Go to Solution.
Hi @AnanditaShankar , here is one way to add all the missing dates. Hope it helps!
The dates should not be generated just based on Min and max dates but for all the dates between 31st Dec-2021 to 31st July 2023
Ah, I think @FinnCharlton 's solution does that.
No it doesn't. i tried it
@AnanditaShankar if you want it specifically between those dates, you can do it like this:
Thanks @FinnCharlton . This is what I wanted.