The link Shane posted is better but if you want the exact date you specified (14-August-2003) try:
<% = day(rsDetail.Fields.Item("AD_DATE1").Value) & "-" & MonthName(Month(rsDetail.Fields.Item("AD_DATE1").V alue) & "-" & Year(rsDetail.Fields.Item("AD_DATE1").Value)) %>
big innit