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:

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