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
AlexChen's avatar
AlexChen
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi,

 

I reproduced you error. It happened because the data type of your “StartDate” and “EndDate” are Text, not Date.

 

Please change them to Date type then follow the steps below.

 

1, original table .

 

 

2. add a new column called “Custom” in query editor

 

 

3. after add the new column, expend the list

 

 

 

4. change the data type of “Custom” column to “Date”

 

 

Best Regards

Alex

 

 

 

 

 

 

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