Track and display dates of updated records
Please advise me how to keep a track of dates when a record is updated and show the history. Thanks
Please advise me how to keep a track of dates when a record is updated and show the history. Thanks
create a column to store the date, using the time stamp data type.
set the default value for the column to:
CURRENT_TIMESTAMP
on the update page, add a hidden form element to capture the date, set the value to:
<?php echo date("Y-m-d h:i:s"); ?>
in the update behavior, bind the date column to the hidden element.
Hi Jason,
What I am trying to achieve is keeping and showing changes made to a date datatype field in a form which in this case is the update page. That's when a user updates the datefield in the update page, the change is recorded and when any other user checks the detail page the history of date changes is displayed in a field.e.g changes made 12/12/2013<br />25/12/2013<br />10/01/2014<br />20/01/2014
what i described above will do that.
Morning Jason, I have done it but nothing is happening, I created the hidden field, bind the date column to the hidden field, but nothing happens. Jason, actually the field in question should be getting it's data from another date field when users update. There is a date field which is court hearing date (date datatype field) that will be set be the user, each time the hearing is adjourned the user updates this field (court hearing date) in the update page.Now what I'm trying to do is to keep the record of all the court hearing dates for each case in the past_hearing_dates field ( which is the date datatype field , you advised me to create) and display these dates in both update and detail pages. Where the challenge for me is how to catalog these dates in the past_hearing_dates field? Please see the update page attached with your instruction. I'll really appreciate your help. Thanks
I dont follow, what precisely is it yoou are having trouble with.
please describe how the results of this page differ from what you are trying to accomplish?
The expected result is not showing. The history of changes made to the next hearing dates are not showing in the past_hearing_dates field, I want to display every change made to the next_hearing_date field in the past_hearing_dates field. Thanks
Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.
We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).
Thanks Jason, is it ok to connect tomorrow Friday between 10am - 11am which is 3pm -4pm GMT ( my time zone ). My skype username is annykaconsultingltd.
Looking to hear from you.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.