Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    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

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

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

Uchiha85's avatar
Uchiha85
New Member
1 year ago

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.