Today

Viewing 4 reply threads
  • Author
    Posts
  • January 20, 2023 at 1:53 PM #48748

    Glen Forister
    Participant

    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.

    January 20, 2023 at 3:07 PM #48754

    Brendan
    Keymaster

    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.

    January 20, 2023 at 5:46 PM #48757

    Glen Forister
    Participant

    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.
    January 20, 2023 at 7:15 PM #48763

    Brendan
    Keymaster

    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.

    January 21, 2023 at 8:01 AM #48769

    Glen Forister
    Participant

    Thanks. I’m getting the hang of this now. I figured out difference in months.

Viewing 4 reply threads

You must be logged in to reply to this topic.