I want a field to show the date of the day I’m looking at the database. I’ve tried a calculated field with in the formula for the field as “Today()”.
That doesn’t do anything. I’m missing something.
You would need to set the Result Type to Date on the Formula Editor for that.
But also TODAY() will return the value the date was when you first saved it. To refresh the result you need to select the Refresh Records List command or click the circular arrow button at the bottom of the records list. That’ll go through all records in that form and re-evaluate all calculation fields for every record.
I used all caps this time, but no change. Refresh many times, editing didn’t help, adding a new record didn’t bring up a date. See attached for settings.
Attachments:
You must be
logged in to view attached files.
Your Calculation field which is returning a date from the TODAY()
function is set to return a Number result value. Change the Result Type to Date
.
Thanks. I’m getting the hang of this now. I figured out difference in months.