Change dataset date format

If there an easy way to change the datasets date format, as YYYY-MM-DD is not very nice for the students to read, if there a simple way for me to change it to DD-MM-YYYY as this is the better way

i have looked around and i can only see changing the sql server but i do not know how to do this through myphpadmin and xampp

bit of a beginner when it comes to sql servers

DataSets by default will use mysql date format, as that’s what mysql date/time functions return, so if you’re using filters for example the comparison needs to make sense.

That being said, you can format the output, perhaps by using formula type column, like in this example - DATE_FORMAT in Ticker?

So the end user will see the date in a more user friendly format, please see here for more parameters values you can use https://www.w3schools.com/sql/func_mysql_date_format.asp