List Days between two dates in date format

building semantic layer
1

Hello

I have Absences Begin date and Absences end date Ex ( 25/11/2018 to 1/12/2018)

i need to calculate field to have 26/11/2018, 27/11/2018 , 28 /11/2018 , 29/11/2018 , 30/11/2018 , 1/12/2018 .

i made function daysbetween to get number of days between two … but i need to calculate a field to show days in above orders :wave:

zahmed (BOB member since 2018-01-14)

2

Hi

Just an input:

I THINK you cant do it at the universe side.

You have to do it in the report. Assuming its webi, use the TIMEDIM-function.

Or create a calendartable in the database, and merge the dates in the report. From the calendertable you will get every unique date.

Good luck
/Björn

Bjorn :sweden: (BOB member since 2006-02-10)

3

Thanks for the answer :+1:

zahmed (BOB member since 2018-01-14)