Need Help: Sorting records by Date is not working -- ?!
I have a simple form that includes a date field. I'm populating a checkbox list with records for the user to choose from.
The code below shows that I am fetching the records and sorting them by date:
The output is: (note the dates in each checkbox line)
WHY? I've successfully sorted records by date in previous forms, why not in this one?
By the time you get around to looking at this I will have changed the code and found a workaround, sad to have to say. So it's pointless to give you the form URL. Please investigate date sorting.
Please advise.
---
Greg
aka datazen1
aka w21admin
Santa Fe, New Mexico
The code below shows that I am fetching the records and sorting them by date:
- clear Choose;
- rec = Workshop_Descriptions[ID != 0] sort by Date_of_Workshop;
- for each r in rec {
- Choose:ui.add(r.Workshop_Name+": "+r.Day_of_Week+" "+r.Date_of_Workshop+" "+r.Start_Time+"-"+r.End_Time+" [ $"+r.Price_Per_Workshop.round(2)+" ]");
- }
The output is: (note the dates in each checkbox line)
WHY? I've successfully sorted records by date in previous forms, why not in this one?
By the time you get around to looking at this I will have changed the code and found a workaround, sad to have to say. So it's pointless to give you the form URL. Please investigate date sorting.
Please advise.
---
Greg
aka datazen1
aka w21admin
Santa Fe, New Mexico