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