Hi,
I have a DB table wich automatically updates the datetime upon editing a record using a form in CF5.
Now I would like to show that datetime (last modified data) into the form.
How can I do that?
Tnx,
Bart Weltens - Belgium
Hi Bart,
Add a custom Code element with HTML like this:<p>Site last updated on {date_modified}. </p>But replace date_modified with the column name from your table. You may also want to re-format the date to make it more user friendly.
Bob
Tnx Bob,
Any suggestions on how to make ik more user friendly?
Bart Weltens
Hi Bart,
What is the format of the saved date that you are loading?
Bob
Hi Bob,
In de DB it is saved as 2018-01-05 17:08:45.
Bart
Hi Bob,
How do I "transform " the date 2018-01-05 17:08:45 to for example 05-01-2018 at 17:08 ?
Tnx,
Bart
Tnx for your aswer Bob.
But where in my form do I put this code in CF5?
Bart Weltens
Hi Bart,
In a Custom Code action after the DB Read action and before the HTML (render form) action.
Bob
