Dynamically display absence dates

[Peter Jambors]

Hi everyone.

Where I work, my employer logs employees' absences by recording the start and end dates of each absence period.

On a screen showing a single employee, these dates are visible in a portal. Is it possible to DYNAMICALLY (i.e. not via a script) display these absences in a calendar?

For example, if the portal shows

Start date---End date

2nd Mar, 2007---3rd Mar, 2007

5th Mar, 2007

then the employee's calendar should show

1st Mar

2nd Mar x

3rd Mar x

4th Mar

5th Mar x

Thanks

[Ender]

You can use a Date to Range relationship for each day of the month (actually 42 to complete the grid). Each relationship would look something like:

Interface <=> AbsenceDay1 =

Interface::EmployeeID = AbsenceDay1::EmployeeID

AND Interface::cDate1 >= AbsenceDay1::StartDate

AND Interface::cDate1 <= AbsenceDay1::EndDate

Where cDateN is the calculated from the first date of the month's calendar plus N-1, were N is the day of the month.

Edited March 30, 2007 by Guest