csv file to include time

[lionel]

Hi,

with the help of this forum (thanks), I have managed to get my csv output working, but would like to include the time and date the form was submitted.

Has anyone got any suggestions as to how to achieve this?

thanks

Lionel

[tvulucy]

Hi

In your form, include this line:
<input type="hidden" name="derive_fields" value="Date=%date%,Time=%time%" />

Then add Date & Time as fields at the beginning of your csv columns list eg

<input type="hidden" name="csvcolumns" value="Date,Time,etc...

Note: you'll need to create a new csv file (and change the csvfile name in the form accordingly) after adding these extra fields - they won't get added into an existing csv file

lucy