Date formats from custom fields when extracting reports

[Mully]

Hi

I have altered some of the custom fields to be date only fields.
When looking in the record of a machines itself the date is displayed in the field in the correct dd/mm/yyyy format but when extracting a report including these fields the data is coming out varied for all machines.

for one machine it will extract as dd/mm/yyyy
for another machine it will extract it as mm/dd/yyyy
for another it will extract it as m/dd/yyyy hh:mm:ss

is there a way to get it to just extract date formats as dd/mm/yyyy?

[Hemoco · Accepted solution]

Dates can be formatted using convert() function. Very useful examples can be found at http://www.w3schools.com/sql/func_convert.asp