Scripting lists based on current weekday

[Jarvis]

I'm not sure if this is a FIND question or SCRIPT question so I thought I would start here.

I would like to automatically generate a report of activities

Using a timestamp field, I would like to establish what day of the week it is (Monday, Tuesday , Wednesday, etc) then find all activities that are supposed to happen on that type of day.

For example: Payroll needs to be faxed on Wednesdays.

If today is Wednesday, I would like to be reminded to fax the payroll. I would like a list of all Wednesday activities.

If today = "Thursday" I would like the list to show Thursday's activities.

Is there a way to script this?

Thanks for any help.

Jarvis

[comment]

Do you have a table of Activities, where each activity is assigned a day-of-week (or several)?

BTW, there is no 'find OR script' question: A find is a find - it can be performed manually, or it can be scripted, but it is still a find. In this case, it can be either find (the result is a found set) or a relationship (the result can be shown in a portal).

[Jarvis]

Yes, I do have a table where each activity is assigned a day-of-week.

I guess what I am trying to figure out is how to make the database know what day it is.

Any ideas?

Jarvis

[comment]

Try an unstored calculation field (result is Text) =

DayName ( Get ( CurrentDate ) )

Or, if you're doing a find:

Go to Layout [ < a layout of Activitites > ]

Enter Find Mode [ ]

Set Field [ Activities::DayOfWeek ; DayName ( Get ( CurrentDate ) ) ]

Perform Find [ ]

Edited February 4, 2008 by Guest

[Jarvis]

Thanks Comment.

This is just what I needed!