Drop-down field sorted as text instead of date
Hi Zoho,
I have a drop-down field on my form, listing dates.
When fetching the data from the form sorted by that field it's sorting it like it's text instead of date.
for example:
ListMe = (Loan_Valuations[ID != null].Assign_Valuation_to_Date sort by Assign_Valuation_to_Date).getall();
will get me
01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Jan-2017,01-Jan-2017,01-Jan-2018,01-Jan-2018,01-Jul-2017,01-Jul-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,30-Dec-2017,30-Dec-2017,30-Jun-2017,30-Jun-2017,31-Dec-2017,31-Dec-2017
How can I fix this?
Thank you
Ravid