Calendar of Events

[CreepyCody]

I have a schedule with 24 events to it. These events have a due date.

Job initiated:<date_1>

Files to client:<date_2>

Final due:<date_3>...etc.

What I would like to do is have the entered dates show up in a calendar layout of Daily Tasks, Weekly Tasks, Yearly Tasks.

This is still in development stage, and with 365 days I want to approach it the correct way.

This is what i was thinking but, looking for different ways of attack.

z_container=global container (2 reps), red box and white box.

For day 1: If(day(date_1 or date_2 or date_3)=1, GetRep(z_container=1),0)

For day 2: If(day(date_1 or date_2 or date_)=2, GetRep(z_container=1),0)

My concern is 24 events and 365 days...is there an easier way to do this.

Thanks for your time.

Creepy

[Factory Pilot]

For a daily view you could...

1. have a field "Daily View Date"

2. have each event with its own record and "Event Date" field

3. create a relationship matching "Daily View Date" with "Event Date" (could be 2 separate files, or could be a self-relationship with one file)

4. view fields/data through a portal based on this relationship.

For a weekly view, you could...

1. have a calculation field "Weekly View Week Number"

2. have a calculation field "Week of the Year" (somebody somewhere has probably got a calculation to do this already) for each event record

3. create a relationship matching "Weekly View Week Number" with "Week of the Year" similar to the daily view relationship

4. view fields/data through a portal based on this relationship, could be sorted by date or whatever.

For a monthly view...

Same song, third verse...

Haven't actually tried to implement this, so "buyer beware." Hopefully this will at least stimulate some creative thinking.