I have a field called "Date Last Reviewed" that only a supervisor can populate. I also have a field called "Last Modified On" that has a timestamp so that the last modification to a record is automatically recorded and is not modifiable.

I am trying to add a field that automatically populates with the word UPDATED whenever the "Last Modified On" field is greater than the "Date Last Reviewed" field. That way, a supervisor will immediately see that an employee has made a modification to the record since it was last checked by a supervisor.

I was able to make it a calculation field and when the condition is met I see the number "1" displayed in the field. How do I make it display the word UPDATED instead?

Thank you,

Kevin

Make it a text field and change the result of the calculation from "1" to "UPDATED".

I was able to make it a calculation field and when the condition is met I see the number "1" displayed in the field. How do I make it display the word UPDATED instead?

Format the field as Boolean and enter "UPDATED" in the 'Show non-zeros as:' box.

BTW, you don't need a field to display the warning: you can type the text directly on the layout and format it conditionally.

Thank you both for your help. I didn't know that I could conditionally format text on a layout. It worked perfectly. That's a very neat trick.

Obviously, I'm new to databases. I appreciate the input from both of you. Have a great day!

Kevin