I'm a newbie and I think I need another table for dates, and a script for this, but I don't know where to begin.

My database has related tables for employees and sections.

I've created a columular "schedule" report that lists the employee name, report to work time, and days of the week across the page. I need to have the date for each day of the week show under the day of the week. Our week begins on Saturday.

The report also needs to show Fiscal Year, Pay Period (1 - 26), and Week number (whether week 01 or 02 of pay period); this would be in the heading of the report.

How do I set up a table that determines the dates based on our pay period and week number? How do I set it up so that if I input Pay Period 14; Week 02; it will place the correct date for the day of the week on the report?

Thanks, your assistance is appreciated.

Pam

How do I set it up so that if I input Pay Period 14; Week 02; it will place the correct date for the day of the week on the report?

Is it the 07/10/2010 ?

If yes, try ( result date )

Let([

first = Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) ) ) ;

saturday = first - DayOfWeek ( first ) + 7

];

7 * ( 2 * ( Pay Period - 1 ) + ( Week - 1 ) ) + saturday

)

See also:

http://fmforums.com/forum/showtopic.php?tid/193214/post/281167/#281167