Importing Date filed with different format | XM Community
Question

Importing Date filed with different format

  • 11 December 2019
  • 2 replies
  • 53 views

Userlevel 3
Badge +11
Dear All,

I am having an issue in data which is sent to Qualtrics survey through an API. The date format received is not reflected on dashboard probably despite changing the date format for that field on dashboard data mapping. I had the same issue with data was imported but solved through changing the date field format..

I need your support and point of view on how to overcome this issue.. screen shots may better represent my issue ..

!

!

2 replies

Badge
Hi Muqaibil,

I came across the same issue and have entered the following formats as a 'custom' format, however my API format didn't include the 'GMT +3:00' element:

yyyy-MM-dd'T'HH🇲🇲ss
YYYY-MM-ddT:00:00:00

This may resolve your query?
Userlevel 3
Badge +11
@JPS and all,

Qualtrics support team provided me with the correct date format and it working fine. Date format would be as followed:

MM/dd/yyyy hh:mm a zZ

Leave a Reply