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
-
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()
-
Edit:
The second part "In the Mac app:..." is not from the manual.
-
Thanks, but I'm not following. I create a formula field and put in _cd? I'm on PC, not Mac.
-
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.
-
Terrific. Thanks to both of you.
-
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?
-
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 !
-
You could also just create a date/time field and give it a default value of Now.
Content aside
- 3 yrs agoLast active
- 8Replies
- 2631Views