NOW()

[kimsturgis]

I would like to insert a record using the insert record behavior and insert the date and time also into the database.   Is this possible?

[bregent]

Read your DBMS documentation. Whichever you are using, there's a way to insert the current date/time by setting the columns default value without having to use server/client side scripting.

[DwFAQ]

The answer to your question is yes; it is possible.

[David_Powers]

To get help in an online forum like this, use a more descriptive subject line and give more details of your setup. You'll find some helpful guidelines in How to get help quickly: http://forums.adobe.com/thread/470404.

If you want to insert the current date and time in a database, you might find that the database system has a suitable data type that does it automatically. For example, MySQL has a TIMESTAMP data type that does precisely that. See http://dev.mysql.com/doc/refman/5.0/en/timestamp.html.