Auto Fill Date Feilds

[TennMan]

I have a database used to register soccer players. Two date fields included are FIRST_ENTERED & LAST_MODIFIED. Filling these with creation date and last modified is simple, but I need something else.

Another field is REGISTRATION_STATUS. This is a text field who's values come from a value list (Registered, Pending, Drop, Refund, etc...). Registration Status is selected from a group of radio buttons.

I would like to have a date field that is filled with the current date whenever REGISTRATION_STATUS changes from "Pending" to "Registered".

Can this be done in FM Pro 4.0v1

[andygaunt]

OK

In your new date field create an auto entered calculation.

If( REGISTRATION_STATUS = "Registered", Status(CurrentDate),TextToDate(""))

This way, if the data changes from pending to registered todays date will fill in, otherwise it will be left blank.

HTH