Entered dates into SQL table using dateSerial. Wish to display the dates to user in format dd/mm/yy. How do I do that?
Or is it FormateDateTime()?<BR><BR>Or, you could just home-roll your own - Day(datefield) & "/" & Month(datefield) & "/" & Year(datefield)<BR><BR>-Doug
FormatDateTime dteDate,1<BR><BR>I think that'll give you what you want
Just can't think of the right syntax sometimes...<BR><BR>.d
It's early, and it's Friday. Hell, I'm barely here right now...
No that doesn't work. Instead of the date being 05/02/02 (i.e. 5 Feb), it is giving me 02/05/02 (i.e. 2 May).