How to filter a report by a date that is the answer to a survey question instead of a metadata field | XM Community
Skip to main content
Question

How to filter a report by a date that is the answer to a survey question instead of a metadata field

  • October 1, 2019
  • 3 replies
  • 169 views

My survey includes a question/field to which the response is a date. I would like to create a report that includes a range of dates in answer to this question, but I can't find any answers about what kind of logic I might be able to use in this situation. I only have the options is/is not/contains etc instead of having choices similar to the metadata field for dates. Does anyone have a solution to this problem? !

3 replies

IsabelPosada_Voce
QPN Level 5 ●●●●●
Forum|alt.badge.img+57
  • QPN Level 5 ●●●●●
  • 121 replies
  • October 1, 2019
Did that field have some kind of validation? or format? (DD/MM/YYYY) Try to go to the dashboard data configuration and create a field where the type is date !

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • October 2, 2019
You need to identify that data as "date" in the data. Without using Vocalize, the best way to do this is to set the question answer as an embedded data in the survey flow then identify that data as "date" by clicking "options" in the embedded data element.

PraDeepKotian_XM
QPN Level 5 ●●●●●
Forum|alt.badge.img+21
  • QPN Level 5 ●●●●●
  • 230 replies
  • October 3, 2019
> @Akdashboard said: > You need to identify that data as "date" in the data. Without using Vocalize, the best way to do this is to set the question answer as an embedded data in the survey flow then identify that data as "date" by clicking "options" in the embedded data element. And ask respondent to enter the date format in yyyy-mm-dd.