Date Function Issue

[xavieravinson]

Hello All

     I am facing a date problem in my application.

I have to use cycle end dates. for each cycle i have to use max of end date. for selection

of cycle the values are coming correct. if i am using a pivot table to view all the cycles

it will always takes the max of cycle end date.

please provide me a solution for the above issue.

Thank you all.

[MK_QSL]

Kindly provide some sample data to work on your issue...

Thanks

[xavieravinson]

My cycle starting from april

for cycle 1 apr 1st is my start date and 27 is my cycle end date

for cycle 2 28 apr is my start date and  25 may is cycle end date like wise

i have to show the onroll on employees which are falling in cycles

[vivek_niti]

Hi,

Create cycles in the calendar and then plot the data against the cycle dimension.

Dimension : Cycle

Measure: Count(DISTINCT Employee)

Regards,

Vivek

[MarcoWedel]

Please create a sample app including sample date.