0

Creation Date

Hello everyone,

I wanted to add a date field in my database, in order to have the creation date of each record.

I was wondering if this date already exists within the records and if it does, how could I retrieve it and show it in my records.

 

Thank you guys!!!

5 replies

null
    • Alan_Cooke
    • 1 yr ago
    • Reported - view

    create a formula field and as the formula add "_cd".  Without the "

    That field will show CreationDate (_cd)

    _md = Modified Date
     

      • pirinisz
      • 1 yr ago
      • Reported - view

      Alan Cooke Thanks a lot man, worked great!!!

      • Alan_Cooke
      • 1 yr ago
      • Reported - view

      pirinisz By the way _cu and _mu gives you Who created and Who modified.

    • Truck Driver
    • Chris.6
    • 1 yr ago
    • Reported - view

    Would love to have this feature! Unfortunately, I don’t think it is working on iOS, which is what I use.

    • Fred
    • 1 yr ago
    • Reported - view
    Chris Thomasson said:
    Would love to have this feature! Unfortunately, I don’t think it is working on iOS, which is what I use.

     Yes, I think they are available in the cloud version.

    You can make your own creation date and modified date.

    In the Trigger on new Record for your table you can add a bit of code to fill in today() into a date/time field called createDate.

    For Modify, you need to decide if you want a history or not. Then you can add to a Trigger after update that either:

    1) modifies a modDate date/time field

    or

    2) create another table that tracks modify date/time.

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 5Replies
  • 205Views
  • 4 Following