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
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