OK I would like to see if this can be done. I would like to make a field up called age. That field will be how old the record is. Lets say I just posted to the database a few seconds ago. That field would bring up: 23sec, or 8min, 3hrs, and even 2days.
I see it can tell you the age from DOB but can it be done for the age of post in sec, min, hours, and days?
Thank you very much for your help and be safe all..
how old a record is
-
TandyServices
- Posts: 15
- Joined: 2015-12-07 22:59
- Location: Largo, Florida
- Contact:
Re: how old a record is
You could use a datetime field and set its default value as the date and time of creation of the record. You could then use the same code for calculating age from DOB but use it with the creation date/time field.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.
-
TandyServices
- Posts: 15
- Joined: 2015-12-07 22:59
- Location: Largo, Florida
- Contact:
Re: how old a record is
Will give that a shot.. Thank you very much for all your help you are giving me..