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
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