Someone else may a know an easier way but...
select the date field
right click and select format field
seelct the date time tab
click on customize
click on date tab
change order to DMY
change Month Format to 'Mar'
Change Day format to 1
change year to 1999
in seperators
First seperator use a formula
if day({DATE}) in [1,21,31] then 'st '
else if day({DATE}) in [2,22] then 'nd '
else if day({DATE}) in [3,23] then 'rd '
else if day({DATE}) in 4 to 20 then 'th '
else if day({DATE}) in 24 to 30 then 'th '
IN seperator 2 use " "
In the TIme tab turn everything off
IP Logged
