Order by data if lookup field
Posted: 2019-05-07 11:59
I tried several times to ask for help for this problem, both in the forum and through support requests but without an answer.
I have a "appointments" table with a "date_appointment" field.
I have another "outcome_appointments" table with a "event_date" field. The "event_date" field is automatically set as an integer because it is a lookup field that points to the "date_appointment" field in the "appointments" table. In addition, the "event_date" field is set as "auto-fill" because the event title is defined by another lookup field that points to the "title" field of the "appointments" table.
The "outcome_appointments" table is set to sort the records according to the lookup field "event_date" descendinghly. Unfortunately the data is sorted alphabetically and not by date (so the highest value is 31/10/2018, then there is 29/11/2018 and so on until 07/05/2019!) As you see date is in european dd/mm/yyyy format that is good for me!
I hope you can help me soon. Thank you so much.
Fabiano
I have a "appointments" table with a "date_appointment" field.
I have another "outcome_appointments" table with a "event_date" field. The "event_date" field is automatically set as an integer because it is a lookup field that points to the "date_appointment" field in the "appointments" table. In addition, the "event_date" field is set as "auto-fill" because the event title is defined by another lookup field that points to the "title" field of the "appointments" table.
The "outcome_appointments" table is set to sort the records according to the lookup field "event_date" descendinghly. Unfortunately the data is sorted alphabetically and not by date (so the highest value is 31/10/2018, then there is 29/11/2018 and so on until 07/05/2019!) As you see date is in european dd/mm/yyyy format that is good for me!
I hope you can help me soon. Thank you so much.
Fabiano