Buy Now
Sign in

Substrings in sorting criteria

doromi , May 29 at 08:28
​I have a problem with the sorting of my CC5 data.​
​I have a field containing the date in German writing, meaning "DD.MM.YYYY". Unfortunately there's no way to use a real date field because the user of the form sometimes has to enter a text string in place of the date.​
​Now I should sort my data with descending date, which would mean sorting by YYYY desc, then by MM desc, then by DD desc.​
​But I have no idea how to enter my sorting criteria - I would need to enter substrings of the data in the field "Order" on the tab "Models", but I only get error messages.​
​Any idea what I could do where?​
​Thanks in advance,​
Hi Doris,
Please see if this StackOverFlow answer helps.
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much