I have a "Last Modified" field on my records and I want to grab the current date and put it in this field whenever someone "Modifies" an existing record.
Anyone know how to accomplish this?
Anyone know how to accomplish this?
Mar 25, 1999, 3:15 AM
User (119 posts)
Mar 25, 1999, 3:15 AM
Post #2 of 4
Views: 2240
Hi donm
You can do something like
$today=&get_date;
and then use $today wherever you want...
<INPUT TYPE="TEXT" NAME="Last_Modified" VALUE="$today" SIZE="12" MAXLENGTH="12">
Cheers
-JO
You can do something like
$today=&get_date;
and then use $today wherever you want...
<INPUT TYPE="TEXT" NAME="Last_Modified" VALUE="$today" SIZE="12" MAXLENGTH="12">
Cheers
-JO
Mar 25, 1999, 7:51 AM
Enthusiast (550 posts)
Mar 25, 1999, 7:51 AM
Post #3 of 4
Views: 2242
That works for displaying it in the record you are modiying - however, once I choose "Modify this Record" button - the modified record now has no date at all in it.
Mar 26, 1999, 3:19 AM
User (119 posts)
Mar 26, 1999, 3:19 AM
Post #4 of 4
Views: 2244
Hi donm
Set up the debug mode on and see what you have for your Last_Modify variable (By the way, the name of the variable needs to be the same as the one defined in your .cfg file).
I guess you would also want to setup this value automaticaly so change it to the following...
<INPUT TYPE=hidden NAME="Last_Modified" VALUE="$today">
Again, Last_Modified needs to be in your db definition in the .cfg file.
Cheers
-JO
Set up the debug mode on and see what you have for your Last_Modify variable (By the way, the name of the variable needs to be the same as the one defined in your .cfg file).
I guess you would also want to setup this value automaticaly so change it to the following...
<INPUT TYPE=hidden NAME="Last_Modified" VALUE="$today">
Again, Last_Modified needs to be in your db definition in the .cfg file.
Cheers
-JO