It appears ordering is not working in chrome, but ok on IE and firefox.
The following is my caml
<View>
<ViewFields>
<FieldRef Name="Municipality"/>
<FieldRef Name="Population"/>
<FieldRef Name="DwellingUnits"/>
<FieldRef Name="Employment"/>
<FieldRef Name="Date"/>
</ViewFields>
<Query>
<Where>
{Filter}
</Where>
<OrderBy>
<FieldRef Name="Date" Ascending='True'/>
</OrderBy>
</Query>
<Aggregations Value="Off"/>
<RowLimit Paged="TRUE">1000</RowLimit>
</View>
I have date rate from 1991 - 2040 on 1 year increments.
Data output from firefox and IE has the right sequence and starts from 1991, 1992, 1993 etc… 2040
Data output from Chrome is a little random: 2016, 1991, 1993, …1992…2000, 2001…
How can I make it sort properly for chrome?