Automate

Hello!

I am trying to promote two fields inside my Evolve web form, to capture the timestamp when a user moves a forms status to in progress (custom field), and when the reviewer completes the form. I want this to be promoted so I can access the data inside SQL, and build reports. I cannot use the ModifiedDate for the completed timestamp, as it changes if a user accesses the ticket in the Documents tab. 

My problem, is that I only seem to be able to create date columns (instead of datetime) inside the Evolve created SQL view (RPT_[formname]_...). I have tried creating both a DatePicker and TextBox element inside the Solution, and then in Form Data -> Field -> Data Type setting the Data Type to 'Date and Time'. 

I then set a rule on the custom Save button, so that when the form is saved with the status as 'In Progress', populate the field with 'now()', which is the Evolve suggested function for timestamp. Unfortunately though, inside SQL and in the form this data is shown just as 2026-02-04, for example. No timestamp info - I want the format to match the ModifiedDate and CreatedDate columns Evolve provides.

Any suggestions or help? Happy to give any clarifications, thank you!

Hi Raphael

Please give this a try - make your date/time fields datatype TEXT  - this doesn't seem to work for datetime datatype fields.

Then apply this formula when you click your button: formatDate(now(), "mm/dd/yyyy hh:mm:ss")

Format Date will allow you to capture date and time in various formats - you can adjust. For example HH will give you 15 instead of 03 for hour.

Hope that helps.

Best Regards,

Sigrid

Hello!

I am trying to promote two fields inside my Evolve web form, to capture the timestamp when a user moves a forms status to in progress (custom field), and when the reviewer completes the form. I want this to be promoted so I can access the data inside SQL, and build reports. I cannot use the ModifiedDate for the completed timestamp, as it changes if a user accesses the ticket in the Documents tab. 

My problem, is that I only seem to be able to create date columns (instead of datetime) inside the Evolve created SQL view (RPT_[formname]_...). I have tried creating both a DatePicker and TextBox element inside the Solution, and then in Form Data -> Field -> Data Type setting the Data Type to 'Date and Time'. 

I then set a rule on the custom Save button, so that when the form is saved with the status as 'In Progress', populate the field with 'now()', which is the Evolve suggested function for timestamp. Unfortunately though, inside SQL and in the form this data is shown just as 2026-02-04, for example. No timestamp info - I want the format to match the ModifiedDate and CreatedDate columns Evolve provides.

Any suggestions or help? Happy to give any clarifications, thank you!

Hi Sigrid,

Thank you for this, I was able to get a working DATEDIFF query in SQL using what you suggested!

What would be best practice for getting the CompletedDate timestamp of a task in a scenario like this, where using the ModifiedDate doesn't make sense as it updates whenever a document is accessed (even if it a completed document that is just being viewed)? Is it just to build your own custom field to store it?

Best regards,

Raphael

Hi Raphael

Please give this a try - make your date/time fields datatype TEXT  - this doesn't seem to work for datetime datatype fields.

Then apply this formula when you click your button: formatDate(now(), "mm/dd/yyyy hh:mm:ss")

Format Date will allow you to capture date and time in various formats - you can adjust. For example HH will give you 15 instead of 03 for hour.

Hope that helps.

Best Regards,

Sigrid

Hello!

I am trying to promote two fields inside my Evolve web form, to capture the timestamp when a user moves a forms status to in progress (custom field), and when the reviewer completes the form. I want this to be promoted so I can access the data inside SQL, and build reports. I cannot use the ModifiedDate for the completed timestamp, as it changes if a user accesses the ticket in the Documents tab. 

My problem, is that I only seem to be able to create date columns (instead of datetime) inside the Evolve created SQL view (RPT_[formname]_...). I have tried creating both a DatePicker and TextBox element inside the Solution, and then in Form Data -> Field -> Data Type setting the Data Type to 'Date and Time'. 

I then set a rule on the custom Save button, so that when the form is saved with the status as 'In Progress', populate the field with 'now()', which is the Evolve suggested function for timestamp. Unfortunately though, inside SQL and in the form this data is shown just as 2026-02-04, for example. No timestamp info - I want the format to match the ModifiedDate and CreatedDate columns Evolve provides.

Any suggestions or help? Happy to give any clarifications, thank you!