Hi there,
A short article about gained knowledge concerning the incorrect Date format in submitted variables thru Multi-Row Variable Sets. Out-of-the-box, for date settings other then yyyy-MM-dd, this does not seem to work as expected. It's listed as a Problem, targeted to be fixed in New York (PRB1325027). Because not every instance will be on New York within 3 / 6 / 9 months, a temporary workaround could be more than welcome.
The Issue
When your system has a date format that differs from yyyy-MM-dd, submitted Date variables through Multi-Row Variable Sets display as (for example) 09-11-0027, 09-11-0034, 09-11-0035, etc.. This occurs while entering the date thru the date picker, manually, etc..
Looking at the submitted variables (Multi-Row Question Anwers table) though, the values do look oke. It's just not represented well in Requested Items.
Workaround
The issue is that the values in the Multi-Row Question Answers table are stored exactly like what the user entered through the Catalog Item / Record Producer. The values should actually be stored as yyyy-MM-dd! Changing the values manually would already fix the issue.
So... updating the values automatically 🙂 Just create a Business Rule and follow these steps:
---
And that's it actually. Hope you like it. If any questions or remarks, let me know!
| If this post helped you in any way, I would appreciate it if you hit bookmark or mark it as helpful. Interested in more articles, blogs, videos, and Share projects on Multi-Row Variable Set I published? - Multi-Row Variable Set |
Kind regards,
Mark
---
