Hi,

You cannot modify the system’s start, end and recorded date. My suggestion would be to set up an embedded data just before the end element(s) of your survey flow and pipe in ${date://CurrentDate/d%2Fm%2FY} as value.

Sorry yes meant to stipulate can we reformat in a new field, rather than overwrite the system generated field. I understand the latter is not possible. Thanks for your response. 

Hi ​@vgayraud 

Thanks for the comments above… I wanted to take this thread one step further as I’d like to convert the date to a number value (so that you can use the max metric in a dashboard widget).  What options are there for doing this and is there something that might enable all back data to be changed (without having to extract convert then re-import or do some sort of API script work).  Have you tried adding a date field in a dashboard settings page and once index then changed the field type to number value?  I’ve not tried it but wondering if that might work.

Thanks

Rod Pestell

Just a quick update on this - using a format of yyyy-mm-dd in the survey data field in a dashboard it is possible to add it in and change the field type to a number set.  you can then (painstakingly) add a mapping for each day and convert eg. 2019-04-22 to 20190422 (or 201904.22).  You can then use a Max metric in a table widget which will then show this value.  So that in some sense gets round the need to change any data retrospectively, however… qualtrics though it would be nice to inject a comma spliting it by thousands so you end up seeing 201,90,422.

So I’m 90% of the way there but the format is the issue now!

Any thoughts most welcome

Thanks

Rod Pestell