FM3: verify by calculation

[DonH]

I'm baaaaaaaaaaaack.

Here is the situation. There is a date that needs to be entered under certain circumstances. The date has to be within the last year. That is no problem. HOWEVER, what has come up is people entering the date when they shouldn't and since there is a verification by calculation on the date, it won't allow them to delete the date.

So I'm trying to figure out how to set the verification up for EITHER blank or within the last year.

I tried IF(IsBlank(theDate),'',figger it is in the last year)

But it just told me that I had to enter a date.

Any suggestions?

FileMaker Version: 3

Platform: Windows 2000

[CobaltSky]

Hello DonH,

I suggest you add:

IsEmpty(theDate) or

before your existing validation calc. That ought to do it.

[DonH]

Mahalo nui loa. I knew that! Sheeesh. Putting in a new system for the ultrasound machines and that is sucking my brain dry.