Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Tracking date field change using calc?


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

Recommended Posts

Hello,

I was wondering if someone can help me. i am trying to keep track of date change on database i am creating. Basically this database keep track of another database when changes are made to any of the fields. i got some of the fields to work but not the fields which are date. it does return the right info from the date field.

this is my calc i have:

If(lookup key cal = 1 & incrementer, "", "") & "Field:

Link to comment
Share on other sites

Not quite sure I understand what it is or isn't doing.

I'm not sure if the ! exclamation mark is having any effect on this, but I would stay away from using any FileMaker operators in my naming of fields. Since the above calculation needs to result in text, you have to convert the dates data used in the calculation to text in your calculation. (i.e. DateToText (end date) just like you did in the first part.

HTH

tongue.gif

Link to comment
Share on other sites

This topic is 7867 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
×
×
  • Create New...

Important Information

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