Hi i'm having a confusing time with date formatting, I'm connecting to an existing mysql database with a date format of YYYY-MM-DD HH:MM:SS (which i cannot change or modify the bespoke software), I'm using the date format of DD-MM-YYYY in the list page to display correct UK date formatting which works correctly.
When i try to search for a date using the date picker nothing is found, when i type in the date manually using format YYYY-MM-DD the query works.
I have tryed changing the date format for the search page but it changes all pages date format. Is there a way to manually change this for selected pages, Or any other ideas would be very appreciated.
Many Thanks