Forum Discussion

ibrahimsharaf's avatar
ibrahimsharaf
Icon for Microsoft Employee rankMicrosoft Employee
10 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
Icon for Advocate II rankAdvocate 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
Icon for Community Champion rankCommunity Champion
9 years ago

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

  • inescosta's avatar
    inescosta
    Icon for Advocate II rankAdvocate 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