Embedded Data field not populating as expected - Language = AR | XM Community
Skip to main content
Question

Embedded Data field not populating as expected - Language = AR

  • March 14, 2024
  • 6 replies
  • 79 views

KBrady
Level 2 ●●
Forum|alt.badge.img+11
  • Level 2 ●●
  • 38 replies

I currently have the following Embedded Data field in my survey flow to provide a date stamp; ${date://CurrentDate/DS} . This works consistently for all languages other than Arabic.  I’m looking for suggestions on how to change this code to have Arabic be consistent with other languages.  The format in my data is populated like the following yyyy-m-d

6 replies

Umang Upadhyay
QPN Level 4 ●●●●
Forum|alt.badge.img+25
  • QPN Level 4 ●●●●
  • 122 replies
  • March 18, 2024

Hi @KBrady ,

To ensure consistency with Arabic language formatting, you can use the following code to generate a date stamp in the format "yyyy-m-d" within Qualtrics:

```
${date://CurrentDate/FullYear}-${date://CurrentDate/Month}-${date://CurrentDate/DayOfMonth}
```

It retrieves the year, month, and day components separately and concatenates them using hyphens ("-") to achieve the specified format.

You can replace the existing Embedded Data field in your survey flow with this code to ensure consistent formatting across all languages, including Arabic.


KBrady
Level 2 ●●
Forum|alt.badge.img+11
  • Author
  • Level 2 ●●
  • 38 replies
  • March 19, 2024

Hi Umang, Thank you, I just tried this and I am only getting “--” as the value when surveys are summitted. I really appreciate your help, what could I be missing?


TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 6083 replies
  • March 19, 2024

Hi Umang, Thank you, I just tried this and I am only getting “--” as the value when surveys are summitted. I really appreciate your help, what could I be missing?

The piped field should be:

${date://CurrentDate/Y}-${date://CurrentDate/m}-${date://CurrentDate/d}

 


KBrady
Level 2 ●●
Forum|alt.badge.img+11
  • Author
  • Level 2 ●●
  • 38 replies
  • March 19, 2024

Thank you! This is almost perfect!… what if I only want one number for a month or day, i.e. “3” and not “03” for March, same for a day, i.e. ”5” and not “05” for the 5th other the month.  double digit days/months are ok,


TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 6083 replies
  • March 19, 2024

Thank you! This is almost perfect!… what if I only want one number for a month or day, i.e. “3” and not “03” for March, same for a day, i.e. ”5” and not “05” for the 5th other the month.  double digit days/months are ok,

I don’t think Qualtrics has a format for piping individual single digit months or days. If you really need that, you’ll probably have to resort to creating a date string with JavaScript.


KBrady
Level 2 ●●
Forum|alt.badge.img+11
  • Author
  • Level 2 ●●
  • 38 replies
  • March 19, 2024

OK Thank you so much!