Buy Now
Sign in

Substrings in sorting criteria

doromi , May 29 2018, 08:28
D
doromi 96
May 29 2018, 08:28 #377991
Hi,

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,

regards,

Doris
GreyHead 64
May 29 2018, 08:38 #377993
Hi Doris,
Please see if this StackOverFlow answer helps.
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much