Jump to content

Last Modified only for one field


This topic is 6518 days old. Please don't post here. Open a new topic instead.

Recommended Posts

In my product database, I need to keep track of when pricing fields are changed. I have set up a field that shows the record modification date, but I really don't need it to change when any of the other field were changed.

Is there a way that I can get the modification date for just one field on a layout?

Version: v6.x

Platform: Windows XP

Link to comment
Share on other sites

It's a workaround, but put the field you want to track in a separate, related database/table. In other words, set up a table with fields for the part ID and price. (Say, PartPriceDB.) Relate it to the database with the part ID, name, etc. via the part ID field. (Say, PartInfoDB.) Now, you can track modifications to the PartPriceDB records, which will be unaffected by changes to the PartInfoDB records.

Version: v7.x

Platform: Mac OS X Panther

Link to comment
Share on other sites

Hi,

Try for example :

Case(YourPriceField1, DateToText(Status(CurrentDate))&"-"&TimeToText(Status(CurrentTime)), DateToText(Status(CurrentDate))&"-"&TimeToText(Status(CurrentTime)))

If there are several fields (this wasn't clear in your post), try Case(YourPriceField1&YourPriceField2&YourPriceField3,...

Link to comment
Share on other sites

This topic is 6518 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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