Convert system captured End date to dd/MM/yyyy and drop time stamp | XM Community
Skip to main content
Question

Convert system captured End date to dd/MM/yyyy and drop time stamp

  • January 21, 2025
  • 2 replies
  • 24 views

Paul_Farrell
Level 2 ●●
Forum|alt.badge.img+5

Hi, 

Would there be a piece of custom JS that would convert the system generated Survey End Date captured from a dd/MM/yyyy hh:mm:ss to just dd/MM/yyyy. For 99% of onward analysis outside of the Qualtrics platform where would look at results by date, we usually end up removing the hh:mm:ss element of end date within Excel to strip it out to a straight date format. 

 

Thanks in advance

2 replies

vgayraud
QPN Level 5 ●●●●●
Forum|alt.badge.img+48
  • QPN Level 5 ●●●●●
  • 364 replies
  • January 21, 2025

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.

 


Paul_Farrell
Level 2 ●●
Forum|alt.badge.img+5
  • Author
  • Level 2 ●●
  • 6 replies
  • January 21, 2025
vgayraud wrote:

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. 


Leave a Reply