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
I've tried replicating this but get the error;
"Expression.Error: The number is out of range of a 32 bit integer value.
Details:
40800.99931"
The start and end date values are datetime rather than date. I've tried swapping them to date but this produces the same error, and ideally I would like to retain the time. Is there a way around this?
All the best,