0

DATE CREATED FIELD

Does this exist? I want to sort records by how recently they were created, but the only option seems to be the automatic field "modified on". Am I missing something? I guess they can be sorted by ID number, but that doesn't give me the actual date. 

8 replies

null
    • Nick
    • 4 yrs ago
    • Reported - view

    From the manual:

     

    _cd - returns the creation timestamp of the current record. Doesn’t appear to work in the Mac app.

    _md - returns the modification timestamp of the current record. Doesn’t appear to work consistently in the Mac app.

     

    In the Mac app:

    -Create a DateCreated (date dield)

    -Trigger on create (table level)-> DateCreated := today()

    • Nick
    • 4 yrs ago
    • Reported - view

    Edit: 

    The second part "In the Mac app:..." is not from the manual.

    • David
    • 4 yrs ago
    • Reported - view

    Thanks, but I'm not following. I create a formula field and put in _cd? I'm on PC, not Mac. 

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Yes in a formula field : date(_cd) for the date created on and date(_md) for the modification date.

    time(_cd) and time (_md) also works to show the time.

    • David
    • 4 yrs ago
    • Reported - view

    Terrific. Thanks to both of you.

    • David_Sarrocco
    • 3 yrs ago
    • Reported - view

    Hi, Imagine I have a record with a lot of fields. I want to add another field on  such record that shows when a particular other field was created or modified. Is it possibile?

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Hi David create your date field (lets call it say Mdate)

    Now in the field that to you want to trigger Mdate to action eg lets say the field is called xMod

    in xMOd 's trigger after update you would put Mdate := _md. or Mdate := 'Modified on'

    that it !

    • jeffhaskin1
    • 2 yrs ago
    • Reported - view

    You could also just create a date/time field and give it a default value of Now.

Content aside

  • 2 yrs agoLast active
  • 8Replies
  • 2620Views