Forum Discussion
Extracting dates from date ranges
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
Hi Zubair_Muhammad, That worked really well! Thanks!
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?
how to do this on custom tables?
Hi Zubair_Muhammad
First of all, thanks for reply on this issue, I was looking for exactly same answer and this help me a lot, thinking in this same case, do you know if there´s a way to calculate the dates in range but considering only Monday to Friday? I´m working also in calculate absences but only that ones that apply to working week.
Thanks in advanced.
