Hello,
I am trying to re-upload a date field from a csv into Qualtrics so that it matches the format of my date optioned embedded data field ${date://CurrentDate/DS}. I am doing this with hopes that I can have one FILTERABLE date location that doesn't get messed up during uploads like the Metadata date fields do. I have tried so many formats in an effort to upload but it just won't allow me to successfully import. If I open my data in a text editor for that column it shows the format 2020-09-17 17:13:56 (although excel recognizes any date field as m/d/yy h:mm) How do I have to format my cells so that it will import? I have tried several ways including YYYY-MM-MM HHss. Also, is there anything that can be done with ${date://CurrentDate/DS} such as using -6 or something to account for the UTC time difference format? How would that be written? This isn't a must for me, but it would be nice as our department likes to filter by an accurate timestamp.
Best answer by PraDeepKotian_Ugam
View original