[CLOSED] [1.0] DateFormat="M$" not working

[Fredrik]

Hi!


Im trying load a store with json data from a WCF REST-service.


The service sends Microsoft AJAX serialized dates (DateFormat="M$").
Unfortunately Ext.Net translates this to DateFormat="n$" when it renders the page.


The problem is in DateTimeUtils.ConvertNetToPHP where Ext.Net translates .NET dateformats to PHP (M translating to n).


Is it possible to change this behaviour? I've included a small testproject to illustrate the problem.


/Fredrik

[Vladimir]

Hi,

Thanks for the bug reporting. We should be able fix it soon. I can suggest to use the following workaround

1. Place the following js function to the page

function parseDate(input) {
   var re = new RegExp('\\/Date\\(([-+])?(\\d+)(?:[+-]\\d{4})?\\)\\/');
   var r = (input || '').match(re);
   return r? new Date(((r[1] || '') + r[2]) * 1) : null;
}

2. Add Convert to the RecordField

<ext:RecordField Name="Birthday" Type="Date" AllowBlank="false">
        <Convert Fn="parseDate" />
</ext:RecordField>

[Vladimir]

Hi,

Another workaround:

1. Use DateFormat="MMM$"

[geoffrey.mcgill]

Hi Fredrik,

A fix has been committed to the Ext.Net.Utilities.DateTimeUtils class to support the "M$" date format.


Revision #2626

[Fredrik]

Thanks for the quick fix! You have made a couple of guys in Sweden really happy.

/Fredrik

[mkshields9w57]

Hi!

Which dateformat should I use for my jsonreader? MMM$ or M$?
I tried both and neither one would work.

In case it helps, I tried the following for my datecolumn format
"yyyy-MM-dd" and "MM/dd/yyyy"

Also will it be able to properly interpret dates prior to 1/1/1970?

Thanks.

[Daniil]

Hi @mkshields9w57,

Please start a new forum thread.

If you feel that the threads are related, please feel free to cross link between two.