Forum Discussion

ibrahimsharaf's avatar
ibrahimsharaf
Microsoft Employee
9 years ago

Getting all dates between 2 dates

Hello guys, I have 2 columns named, start date and end date, I want to create a column which contains all the dates between the after mentioned dates, for example      
Need Help
Show and Tell
Tips and Tricks
inescosta's avatar
inescosta
Advocate II
9 years ago

Hello,

 

I am trying to reproduce this solution but I get an error saying Number.from doesn't exist.

ImkeF's avatar
ImkeF
Community Champion
9 years ago

M is case sensitive. So it should be Number.From

  • inescosta's avatar
    inescosta
    Advocate II
    9 years ago

    Can I use M in the table itself or does it have to be in queryeditor? I ask because my table is already changed. the dates shown are from a related table, so those columns don't appear in queryeditor.

    Thank you