Report based on date

[Rattlesnake]

hi,

I'm new to filemaker5.5 . I have a filemaker database that stores employee details including their passport details. I want to create a report that will display only those employees whose passports will expire in the next 3 months.

Can anyone help me with this?

Thanks a lot

[andygaunt]

Do you want 3 months (anytime in the month, exactly 3 months from that day, or a rough 3 months.)?

If rough, you could create a calc ( lets call it PassportCalc) that is

If(PassportDate <= (Status(CurrentDate)+90), 1, 0)

Then you can write a script that will

Enter Find Mode [no pause]

Set Field [PassportCalc, 1]

Perform Find [no restore, replace found set in version 6]

Go To Layout [Your Report]

HTH