Date issue

[Apache]

Hi all... I just need to get result for this given inline

Load
*
Inline [
Event_Type, Event_Date, Hospital, Department,
A, 2/4/2019, HOSPITAL A, SURGICAL
B, 3/3/2019, HOSPITAL B, ICU
A, 1/10/2019, HOSPITAL C, MEDICAL
B, 3/8/2019, HOSPITAL B, ICU
C, 2/28/2019, HOSPITAL A, OR
C, 1/20/2019, HOSPITAL A, OR
C, 2/15/2019, HOSPITAL A, OR
A, 3/19/2019, HOSPITAL A, ICU
B, 3/18/2019, HOSPITAL B, ORTHO
];

I just need the starting date and ending date from the given date and i took both from and end by max and min function now the problem is C is contain 3 dates and the from date is 1/20/2019 and end date is 2/15/2019 but it moves to 2/258/2019 its skipped 2/15/2019... help me on this... thank you

[Channa]

=date(max(Event_Date),'DD/MM/YYYY')

=date(MIN(Event_Date),'DD/MM/YYYY')

[Apache]

Hi Channa Thank you...

I had tried this but the date is missing... 

It only displaying the max date and min date 

i just need the 1/20/2019 as from date and 2/15/2019 this as end date 

and too 2/28/2019 as the starting date and today is the end date...

Thank you

[Channa]

please find the attach QVF 

it is showig as you request

[miskinmaz]

Hi,

Please look for interval match topic on community. It will help to generate the today as end date where there is no end date.

Or you can go through the below article:

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/create-dat...