New

Last Updated Field in Customers/Price Lists not recognised as a date field so cannot be sorted by date

I called Sage support and they were unable to help with this issue and suggested I raise it here.

- Select Customers Module

- Click Price List 

- Price list has the headers: Name/Description/Last Updated/Currency

Issue:

'Last Updated' looks like a date field (02/02/2022 or 02/09/2019)

However, the field sorts as if it is an 8 digit number (02022022 or 02092019) so dates do not appear in order.

This is a sample of how my list appears if sorted by 'Last Updated':