Need help with filling missing dates
I have 2 date fields. One is start date and other is end date. Is there any way we can add the missing dates between start date and end date for a record. Suppose, the start date is 21st March and end date is 28th March, is there any way we can fill missing 6 date values from start date by taking end date as a reference.
I know that there is a fill function but that is not working with end date as a partition. It is only taking dimension which is of string type (correct me if i’m wrong here)
Please suggest
Thanks!
Escribir un comentario...
0/9000