Time Sheet DB: Prevent Overlapping Dates

[csmedsrc]

First of all I just want to say how helpful this forum has been for someone learning Filemaker.

I have created a time sheet database but I need to add some validation. Time sheet records are all stored in the same table. Each record covers a period of two weeks and begins on a Monday. Everything is working but I realized that I need a way to prevent people from creating time sheets that include any of the dates from a previous pay period.

Currently, employees choose the starting Monday of the pay period from a drop down calendar and then click on the create button which launches a script that creates the record and fills in all the dates of the two week pay period (the script also checks that the selected day is a Monday and tells the employee to change it if it is not).

I need to add some validation to this script so that there is no chance of overlapping days between time sheets. Any ideas on how to do that?

[lisaniel]

Hi!!

By chance I came across this post..

have you got a solution for your query or still searching for it, if so let us know.

Edited May 25, 2010 by Guest