Hello,
We have a form that has input done by people in Mexico and in the US. Because of this I had to change the formatting on the date picker field in the field's properties to 3/14/2001 without the * because if you use the * it will pull up whatever date settings are on that user's computer. We want the date to always show as MM/dd/yyyy.
On the date picker field, I have a rule set that when it changes, it sets a different field called "custDateFormatted" and I have the code set to perform this action: concat("FormatDate /date=", ., " /format=MM/dd/yyyy")
This works fine 90% of the time. However, sometimes when the user enters a date, such as 8/2/2017 in the date picker field, it shows up as 8/2/2017 in that date field, but the qRules code above translates it as 02/08/2017 in the custDateFormatted field.
This happens even when the person is using an US computer. That same person can enter the date on many other forms in the same system and it gets entered correctly, but sometimes it shows up wrong.
In addition, this is happening to many different people, sporadically.
The problem is that the dates being entered are customer due dates. So if the due date is actually August 2nd but it wrongfully shows up as Feb 8th, then obviously we will miss our customer due date, so this is a huge issue.
Do you have any idea why this would be happening so sporadically? Is there any other ways I an force the date to always translate as MM/dd/yyyy?
Thank you in advance.