Question

Embedded Data Date option fields returns no value?

6 years ago
Sep 9, 2020 6:17 PM UTC
3 replies
521 views

+11

Martin_O
Level 2 ●●

I am trying to recreate Recorded Date in an embedded data field so that after some data cleanups/re-uploads I can preserve a filterable date in one spot. For some reason when I select Date under embedded data options and then selecting a value under Current Time, nothing is being generated during my survey responses. If I change it to a text field, it works fine, but if filtering options are available under a date field, I would prefer that. Any suggestions?

+27

TomG
Level 8 ●●●●●●●●
6 years ago
Sep 10, 2020 7:41 PM UTC

Use the ISO date (${date://CurrentDate/c} to populate embedded data fields with the variable type Date. The only issue is that it will populate in UTC time, not the timezone your Qualtrics account is set to.
I tried piping pieces of the current date and concatenating them with a timezone offset into ISO-8601 format, but it still converts it to UTC in the data.

Like

+11

Martin_O
Author
Level 2 ●●
6 years ago
Sep 10, 2020 8:41 PM UTC

TomG

Always looking out for me Tom! I appreciate it. I also was given ${date://CurrentDate/DS} as I ended up going to support on this one. It looks like the one you provided also shows the timestamp. For the one you provided, I am getting the correct timezone, but I used CurrentDate instead of Current to get that. Interestingly enough though the filter is actually a day behind, even though the timestamp and date match my timezone (Mountain) correctly.