2. ASPRunnerPro General questions
  3. Insert date and time before record added on Edit page.
This topic is locked

Insert date and time before record added on Edit page.

 		7/25/2013 5:19:53 AM
ASPRunnerPro General questions
M
 markynewport author

Hello again,
I would like to add a date and time stamp to a field everytime that field has been updated...
something like this
Customer information field......
this is the orignal data entered to this field.
25/07/2013 10.00
This is the record updated...... (for the first time)
I hope I am making sense.....
Thanks,

Mark.
T
 		Tim 8/22/2013

set the default value of the date/time field to Now() and tick the "Apply on the Edit page as well" box.
From the help file:

"If you enable the Apply on the Edit page as well check box, default value will be applied every time record is updated. You can use this feature to keep track of who and when updated the record."
G
 		gonzalosb 10/10/2013

if you wan the date not to be modify by the user, so he/she can "CHEAT" changeing the date, add - Now() - on readonly field.
if you wan to leve the date to be modify when you create the record but as a timestamp as a readonly, marck the checkbox on top:

" use diferent settings for all pages "
and Now() on date the ADD Page and readonly on EDIT Page.
hope this help.