Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Date Stamp Field

Paul Bishop
in Relationships

Featured Replies

  • Newbies

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 ]

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))

  • Author
  • Newbies

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

Paul laugh.gif" border="0

Create an account or sign in to comment

https://fmforums.com/topic/3924-date-stamp-field/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.