select the date from ms access in dd.mm.yyyy format

Question

I want to select the data from the database using select command but the result is showing in yy.mm.dd format while i want the result in dd mm yy format I am using the following commad

  select  date from table1 order by date desc;

how can i get the date in dd mm yyyy format please help me

Answer 1

You need to user format function for date.

select format([date], "dd.mm.yyyy") from table1 order by [date] desc;