Date Format Issue while exporting data | XM Community
Skip to main content
Solved

Date Format Issue while exporting data


Forum|alt.badge.img+1

How to change the date format in qualtrics as there are multiple date columns which are shown up as numbers.

 

Best answer by AlonsoC

lizb311 wrote:

@sushant_ln1711 hm, okay, well definitely revert it back if that didn’t help! A few other ideas / questions:

  • It looks like your original data is just in the “number” format - like what Excel shows if you change a date to a number (i.e., the number of days since 1/0/1900). If you download the data to Excel and then highlight that column and change the cell format to custom date formatting, is it correct? 
  • I don’t know if this support post would be relevant for your situation? 
  • Are you setting your embedded data via JavaScript, or just in the survey flow? And similarly, what format are you trying to put your embedded data in, when you’re setting it? It looks like acceptable formats are: 
  •  

@lizb311, thanks for these in-depth suggestions! @sushant_ln1711, did any of these tips resolve your issue?

View original

4 replies

lizb311
Level 3 ●●●
Forum|alt.badge.img+20
  • Level 3 ●●●
  • 119 replies
  • April 8, 2024

Is that column from a survey question or an embedded data field? If it’s embedded data, try clicking on “Options” and then changing the variable type to “Date”?

 


Forum|alt.badge.img+1

Hi @lizb311 ,

 

I tried changing the text to date but when I download the data the column shows up blank.


lizb311
Level 3 ●●●
Forum|alt.badge.img+20
  • Level 3 ●●●
  • 119 replies
  • April 17, 2024

@sushant_ln1711 hm, okay, well definitely revert it back if that didn’t help! A few other ideas / questions:

  • It looks like your original data is just in the “number” format - like what Excel shows if you change a date to a number (i.e., the number of days since 1/0/1900). If you download the data to Excel and then highlight that column and change the cell format to custom date formatting, is it correct? 
  • I don’t know if this support post would be relevant for your situation? 
  • Are you setting your embedded data via JavaScript, or just in the survey flow? And similarly, what format are you trying to put your embedded data in, when you’re setting it? It looks like acceptable formats are: 
  •  


AlonsoC
Administrator
Forum|alt.badge.img+13
  • Administrator
  • 227 replies
  • Answer
  • July 30, 2024
lizb311 wrote:

@sushant_ln1711 hm, okay, well definitely revert it back if that didn’t help! A few other ideas / questions:

  • It looks like your original data is just in the “number” format - like what Excel shows if you change a date to a number (i.e., the number of days since 1/0/1900). If you download the data to Excel and then highlight that column and change the cell format to custom date formatting, is it correct? 
  • I don’t know if this support post would be relevant for your situation? 
  • Are you setting your embedded data via JavaScript, or just in the survey flow? And similarly, what format are you trying to put your embedded data in, when you’re setting it? It looks like acceptable formats are: 
  •  

@lizb311, thanks for these in-depth suggestions! @sushant_ln1711, did any of these tips resolve your issue?


Leave a Reply