I want to validate the input in my Date field by a calculation.

I have the fields:

EmployeeID

Date

It has to check if the date already exists for that user and if the date is older than tomorrow.

thanks in advance

you will need another occurrence in your graph of this table

Not necessarily:

http://fmforums.com/forum/showpost.php?post/204677/

Is this what you mean, Michael?

Almost. The concatenating text field must be validated for Unique, Validate always. That takes care of the first requirement.

As for the second requirement, you could add it as 'Validated by calculation' to the same field, or validate the date field separately. The former may be simpler, but splitting the validation between the two fields allows you to pinpoint the message to the user. With a combined validation, the message is by necessity vague.

I tried that approach but then I get the problem

that only one user can use a date.

I want all my user to use dates from today and earlier but a user can only use a date once.

I tried that approach but then I get the problem

that only one user can use a date.

No, any user can use any date once. After that, the used date becomes unavailable to that user, but other users are not affected.

I'll make an example of it and post it later.

Maybe you can help me with this:

I'm making a script but I want to add a feature

that compares the current date with the found records and if the current date does not exist

it makes a new record.

What I got so far:

Go to Search

set field emloyee with user

set field checked with no

Search

Sort

if (:Date = Get (CurrentDate))

Go to First

else

New record request

end if

Sorry I wasn't clear about that but I mean that they can fill in dates from today and from days before today like yesterday ???