Hi there
This is probably a very stupid question from an ASP beginner but I hope that somebody will be kind enough to help me out here.
I am sending a Date that the user enters from a form on my asp.page, to the Access 2000 Database.
I have set the field in the Access database table which stores the Date to, DATA TYPE: Date/time and the FORMAT: Medium Date.
In the database the date is then displayed as eg. 14-Aug-03.
However when I display the date on my DETAIL Page it looks like this 14-08-2003. I want it to display as 14-08-03.
To display the date on my DETAIL page I use the following code:
<td width="9%" align="center" bgcolor="#FFFFFF" height="18"><p style="margin-top: 0; margin-bottom: 0"><font face="Verdana, Arial, Helvetica, sans-serif" style="font-size: 11px"><%=(rsDetail.Fields.Item("AD_DATE1").Value)% ></a></font></p></td>
How can I control the way the date is displayed? Do I have to change some settings in the Access Database that holds the Date Field, or do I require some kind of script in the code that is calling the script.
Thankyou in advance.
Regards
Kaikki