I have dates which i need to perform calucations upon (add 14 days to etc), which are held in a database. I can easily do this by using the DateAdd function. The only problem being is that I can only format the date into the following format:-

21 June 2000

When I need the date to be in the format:-

21st June 2000

Any ideas would be much appreciated !

Thanx !