Date Stamp Field

[Paul Bishop]

I'd like to set a date field to the current date when the data in a field changes to specified criteria. For example: I have a text field called Record Status. Sample data for Record Status would be: "Not Yet Started", "Started", "On Hold", "Not Resolved", "Resolved". When records are imported into my FMP db, Record Status is set to "Not Yet Started". I want to set up a date field which will pull the current date when Record Status is changed from "Not Yet Started" to any other disposition. The problem I've had is when Record Status is changed more than one time (i.e. if Record Status is changed from Not Yet Started to Started on 11/1/01 and then on 11/2/01 it is changed from Started to Resolved, the field will show 11/2/01 rather than 11/1/01 - which is the actual "Start Date"). I realize this could be done with scripts, but I'd rather have it work like automation. Any suggestions would be greatly appreciated.

[ November 08, 2001: Message edited by: Paul Bishop ]

[ November 08, 2001: Message edited by: Paul Bishop ]

[BobWeaver]

Make your date field options "Auto-enter calculated value" and use this for the formula:

Case(IsEmpty(Record Status) or (Record Status="Not Yet Started"),"",

Status(CurrentDate))

[Paul Bishop]

Okay, That was too easy! You wouldn't believe all of the variations I've tried. Thanks a bunch!

Paul