Anyone know how can i change the format of a date stored on a access database, because when i go to detail page the format on my recordset say (dd/mm/yy) but in my database is (dd/mm/yyyy)

You don't need to change format of a date in DB. Change format of a date you're displaying in page. There are few articles on this site that can help.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Anyone know how can i change the format of a date stored on a access database, because when i go to detail page the format on my recordset say (dd/mm/yy) but in my database is (dd/mm/yyyy)
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

on which article or section?? please help me

In the Server Behaviours window bouble click on the Dynamic Text you want to format.

Select the Format you want from the drop down list.


Regards

Owen



www.tdsf.co.uk/tdsfdemo

ok thanks, it work for my first problem, but now i need to select on the format list this format (date dd/mm/yyyy) an the format list doesn't have this format anyone how can i create it?

Try dd/mm/yy, I think you'll find it works. It did on my site which is hosted on a US server which as standard displays dates as mm/dd/yyyy.

Regards

Owen.



www.tdsf.co.uk/tdsfdemo

You should set 'Locale ID' in order to have date displayed in your country format.
Take a look at this link: www.udzone.com/showDetail.asp?TypeId=3&NewsId=796
You can also make it displayed like dd/mm/yyyy by hand coding but above solution is much easier and faster.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ok thanks, it work for my first problem, but now i need to select on the format list this format (date dd/mm/yyyy) an the format list doesn't have this format anyone how can i create it?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

i couldn't change the date format because the extension what i use to validate forms only has formats with dd/mm/yyyy

-----------------------
Try dd/mm/yy, I think you'll find it works. It did on my site which is hosted on a US server which as standard displays dates as mm/dd/yyyy.