Date Alert needed

[Buck.Barnibus]

Hello, I'm new to FM so i dont even know if what i'm wanting is possible.

I have a date feild for when a vehicle is taged. What I need to know is how to set an alert to give me a 2week notice before the tags are due.

I've tried the brithday alert script but alas no go.

Any help with this one would greatly be Appreciated.

[mr_vodka]

As part of your opening script, it can check to see if today's date is 14 days prior to the due date. If so, it can alert you and find those vehicle records.

[merkaba22]

I was just looking into this possibility -- nice idea.

Do you have an example of the opening script you suggest or is, the timing, 2weeks, and the alert itself a built-in function that is self-evident.