Substrings in sorting criteria

doromi 29 May, 2018

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,


This topic is locked and no more replies can be posted.