I have created a form.  Within that form, I want to record the current/date time that a record is created.  I am trying to do this with the Variable contruct.

Here my declaration

<Variable Name="DateTimeSubmitted" Value="{XMOD_Now}" DataType="string" />

When the form submits, it tries to insert a new reocrd in the database with the DateTimeSubmitted as one of the fields.

I get an error that says the following:

Conversion failed when converting date and/or time from character string.; ADDITIONAL INFO....DateTimeSubmitted:{XMOD_Now};

This leads me to believe that the variable is not getting replaced with the actual date/time.

Please help!