date updated field

[jockm]

I'm using FP 11 with MacBook pro System 10.6.8.

 

I have a database of about 3000 records with various fields, one being "date created".

 

I want to add a field to my layout for "date updated" so that whenever I make a change to a record, this field shows the date of that last change. 

 

This ought to be pretty simple but I dont immediately see a way to create such a field in my layout.

 

thanks

[Raybaudi]

Yes, it's pretty simple...

Create a new field, type date or timestamp, and set the option of auto-enter the record modification date or timestamp.

 

[jockm]

Brilliant! Many thanks. 

[jockm]

Now I have got this DATE MODIFIED field into my record along with DATE CREATED. However the formats of the dates are different. One of them is 28/09/2013 and the other one is  28 Sept 2013.  I cannot see any way to make them the same (28 Sept 2013 is my preference). I looked at the options for the field but the date format is not shown as an option.

[LaRetta]

Are you really on version 7?  If you look at field behavior setting (or Inspector on newer versions of FM), you can set the data format at the layout level.

 

In Inspector, it is the data tab.  You can change the date to many different formats this way.  

[Lee Smith]

The first post shows 11 in the body.

 

@Jockm

 

Please update your profile to reflect your current FileMaker, and OS, here is a quick link MY PROFILE

[jockm]

Thanks. Inspector DATE did it.

[Lee Smith]

In my previous post I asked that you should also update your OS info.

[jockm]

Yes, done

[Lee Smith]

Not quite, are you using a Mac, PC or both (cross platform)?

 

What is your skill level?

 

Knowing the answer to these questions can sometimes help us better respond to your questions.