Qdabra qRules

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Hilary Stoupa — Thu, 30 Nov 2017 22:28:20 GMT

Thanks for sending your form - I can't get the issue to reproduce, which isn't surprising since you've mentioned it doesn't always happen. However - I am perplexed by the design of the form. Can you help me understand why you need this additional field instead of promoting the dueDateFromCustomer field to the library? XML stores the date value as yyyy-MM-DD. I also don't understand why there is a field that is not inside the repeating group in the schema being used inside the repeating table for this....

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Hilary Stoupa — Mon, 30 Oct 2017 14:51:22 GMT

Hi - I haven't seen an email about this yet - did you send it?

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Deeayrian — Mon, 23 Oct 2017 19:40:57 GMT

Yes. I'll send it to you shortly.

Thank you.

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Hilary Stoupa — Mon, 23 Oct 2017 19:36:47 GMT

I'd like to see the form template as well as sample XML that show forms that have had the issue. Can you send those to Support AT Qdabra DOT com & reference this thread?

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Deeayrian — Mon, 23 Oct 2017 18:25:03 GMT

It is a date, with the date formatting set as 3/14/2001

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Hilary Stoupa — Mon, 23 Oct 2017 17:01:49 GMT

I understand that you are using a date picker control - I'm wondering about the data type of the field. Is it a date? DateTime? String?

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Deeayrian — Mon, 23 Oct 2017 16:43:01 GMT

Hello Hilary,

Yes, it is the date picker field that is described in the first paragraph.

Re: FormatDate sometimes returns dd/MM instead of MM/dd

Hilary Stoupa — Thu, 19 Oct 2017 14:48:12 GMT

So - the field the user enters data into - what is the data type? Is it a date field?

FormatDate sometimes returns dd/MM instead of MM/dd

Deeayrian — Mon, 16 Oct 2017 23:09:00 GMT

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.