Forum Discussion
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
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
Dear AlexChen
I was looking for a similar solution like what you have posted. However, my data has values for each row and those are getting duplicated as the number of rows get duplicated for the date range. So I cannot get a sum of the valyue. e.g. Sum(Cost).
What do you reccommend for that please.
Thanks
Senarath