Have a field I want to auto enter a date whenever it is modified.

Is there a way to use &get_date whenever the record is modified?

Thanks


joeh

Yes...Create another field called ModifiedDate, which should be the same as the Date Added field. Then add delimiter character to all your records in your existing database. You have to do this anytime that you add a new field to the db_def section of the default.cfg file.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

Got that part. Actually I needed to have the Date Modified text box in the modified screen automatically put todays date in it. I am playing with the idea of putting &get_date in the field data of the html code and just submit that when the form is submitted.


joeh

Uh...The suggestion I gave will do this!

Regards.

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

Then I mush have done something wrong, because when I tried, it only set it for records that were new. The existing records still maintained their old or non-existent date.

I used &get_date in the html_record section along with a test to see if I was in modify mode to get around that.


Thanks

joeh