Hi, I have users submitting request for our services via the web. I have input boxes and textboxes. I would like to use a hidden text box to submit the date and time when they submitted this request. I have tried the following but it gives me an error.

<INPUT TYPE="hidden" NAME="submitted" VALUE="-[currentdate]">

what is the correct way to phrase this.

my database field is named submitted and is a date field.

Any help is appreciated

------------------

Robert Hernandez

Programmer

http://www.rgvwebs.com

Thanks a lot for your help!

I really appreciated.

------------------

Robert Hernandez

Programmer

http://www.rgvwebs.com

I am assuming that each time somebody uses your site that they create a new record in the database.

In which case all you need to do is select the options button for your date field in Define Fields area of FM Pro. Then, select the autoenter tab and check the top option that says autoenter a creation date. Then, everytime somebody creates a new record the relevant date will be filled in. This also applies to the time field.

You do not have to do anything within the CDML other than post the -new command that tells your datbase to create a new record.