Forum Discussion
Extracting dates from date ranges
Hi all, I have a data coming from our HR tool like this: Name Start date of absence End date of absence John Doe 01/10/2018 02/10/2018 Jane Doe 02/10/2018 05/10/2018 I w...
Anonymous
In the Query Editor..... Add a custom column as follows and convert it to date format
It will give you a list of dates from start to end.
{Number.From([Start date of absence])..Number.From([End date of absence])}Then expand the list to new rows
See file attached as well
Anonymous
In the Query Editor..... Add a custom column as follows and convert it to date format
It will give you a list of dates from start to end.
{Number.From([Start date of absence])..Number.From([End date of absence])}
Then expand the list to new rows
See file attached as well
Ist there also a formular for doing it the other way around.
So to get a Coloumn for each day to start and end date?