Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

List dates between two dates

Hi all, I'm looking for a formula to list dates between 2 dates. Suppose I have the following example: Column A) InitialDate: 19/07/2019 Column B) EndDate: 19/10/2019 so, I would like to get as r...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Anonymous 

    you don't use it as a function. Then the "each" isn't ambigous any more.

    Try this for result instead:

    Result = List.Transform({0..NoOfIntervals}, (x) => Date.AddMonths([FROM], x))

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

I thankful with the early repply, however I'm still facing errors. Please check the screeshots for more details.

Screen1 

Screen2 

 

Thanks in advance

Inacio11

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

you don't use it as a function. Then the "each" isn't ambigous any more.

Try this for result instead:

Result = List.Transform({0..NoOfIntervals}, (x) => Date.AddMonths([FROM], x))