Good day to you all.
To display the date like 24-May-2004 I use:
<%Response.Write (Day(Date) & "-" & Monthname(Month(Date)) & "-" & Year(Date))%>
Now if I have stored a date like that in my Access DBase, how do I retrieve it in that same format? Ie, the field name "myDate", if viewed in Access comes out 05/22/2004. How do I use that little script above to format myDate when view in a browser?
Any help much appreciated.
William
To display the date like 24-May-2004 I use:
<%Response.Write (Day(Date) & "-" & Monthname(Month(Date)) & "-" & Year(Date))%>
Now if I have stored a date like that in my Access DBase, how do I retrieve it in that same format? Ie, the field name "myDate", if viewed in Access comes out 05/22/2004. How do I use that little script above to format myDate when view in a browser?
Any help much appreciated.
William