Fetch data between selected dates

[Anonymous]

I have a leave management application where user apply leave from and to date. e.g. 12/1/18 to 19/1/18. Now i wish to add calendar control (day field) which would reflect this record if any value selected between 12 to 19 like 13,15 etc.

Currently i added from date and to date controls which doesn't reflect the record if select 13,15.

Thanks

[tresesco]

Check the video here:Selecting Arbitrary Date Ranges

[Anil_Babu_Samineni]

Please start google -- Date Arbitrary is the solution

[mdmukramali]

Hi,

You have to Generate all the Missing dates by using Master Calendar :

Suppose you have Leave Start date and EndDate e.g. 12/1/18 to 19/1/18.

there is no record available for that employee in the System for 13,15.

for that, you have to generate the calendar for each day and need to check the status of the all the employees.

can you share sample data file?

Thanks,
Mukram.

[Anonymous]

Not solving the problem. In my data i don't have any record (line) with date 13 or 15 like in your example you have all dates in the field order date.

[Anonymous]

Want to avoid generating those rows which are considered on between dates (i don't know how ). Attached is the sample data file and app.

Here date 20.12 is between leave 18-22 for employeeID 60. So if i select 20.12 in calendar... it should also show this record.

Thanks.