Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

Formatting dates in my Qualtrics CX Dashboards

Sarthak
Sarthak DelhiCommunity Member Qubie ✭
edited June 23 in CX Dashboards

Hello Experts,

In my scenario I am taking date from an API and want to show it in my dashboard.

I have an embed field(String Type) in which I am storing it , If I choose "Date" Type in Embed field then it is not visible in Data & Analysis tab.

Also I am using Javascript to convert this String to Date, But still its not visible in Dashboard.

In Dashboard I am trying to set Format for both these field but it is still not visible.

I went through these 2 links & formatted dates as mentioned below:


Dates & format I tried:

May 22, 2020 8:17 AM -- MM dd, yyyy K:m a

May 22, 2020 -- MM dd,yyyy

Fri May 22 2020 08:17:00 GMT+0530 (India Standard Time)-- E M dd yyyy k:m:s zZ

2020-05-22T02:47:00.000Z - Not sure

None of it is working, Can anyone please help on this?

Thanks & Regards,

Sarthak Srivastava

Tagged:

Answers

  • PraDeepKotian_Ugam
    PraDeepKotian_Ugam Mumbai, IndiaCommunity Member, Qualtrics Brand Admin Superuser ✭✭✭✭

    Hi @Sarthak ,

    In my case I had the same problem and it was not appearing in the data and analysis.. so i have tried using the date format of Qualtrics metadata date i.e using yyyy-mm-dd format. And mapping the same date format in dashboard.

  • Muqaibil
    Muqaibil Community Member, Qualtrics Brand Admin Guru ✭✭

    Hi @Sarthak


    what is the format of your date source..?

    any date retrieved from external system will not be identified in terms of format as same as metadate dates of Qualtrics..

    Thus, simply try to find the correct format used in the 'date' source and apply the same in dashboard mapping of fields. if you apply the date as a 'text' field, it will show all the dates in a list not date intervals.

    in case you could not find the correct date format, report the sample of your date to Qualtrics support and they will provide the right format for you..


    Best Regards,

    Muqaibil

  • Sarthak
    Sarthak DelhiCommunity Member Qubie ✭

    Hello @Muqaibil ,

    The date format from the source is:

    May 22,2020 8:17 AM, I am taking this as Text in embed field and converting to Date in Dashboard using this format- MM dd,yyyy K:m a

    Is this correct?

  • Muqaibil
    Muqaibil Community Member, Qualtrics Brand Admin Guru ✭✭

    Hi @Sarthak


    Yes in terms of the process followed but not sure about the used format..

    based on the mentioned example , try MMM dd, yyyy h:m a as you are already applying the AM/PM difference in the data source..


    BR,

    Muqaibil