Using NOW()

Viewing 3 reply threads
  • Author
    Posts
  • October 6, 2017 at 10:33 AM #25178

    tonyt
    Participant

    Hi
    Is there a way to stop the time appearing in a field set to show todays date?
    I added this field to an existing form at a later date. Is this why the date is not showing up in old records?
    If so, is there a way to sort it out so todays date DOES show in ALL records?
    Many thanks as usual…

    October 6, 2017 at 11:06 AM #25180

    Brendan
    Keymaster

    You can customize the Date Format at the bottom of the field properties inspector panel when you have your Date field specified. Make sure your Calculation field returns a Date value. Then you can customize whether or not you want the time to appear.

    October 6, 2017 at 11:12 AM #25185

    tonyt
    Participant

    Thanks Brendan,
    And q2 and q3, or am I missing something from your reply?
    Cheers….
    Tony

    October 6, 2017 at 12:48 PM #25191

    Brendan
    Keymaster

    oops. Sorry.

    Just adding a Calculation field with TODAY() or NOW() in it should give you what you want on every record. Set the Result Type to Date.

    The Default Value setting on a regular Date field will only add the current date when you create new records.

    But why do you want the current date to show up on every record?

Viewing 3 reply threads

You must be logged in to reply to this topic.