Hi,

Special Thanks to Marth Graham for helping on the last probem.
I could use your help on a new issue.
I have setup a Database structure that uses

DD/MM/YYYY HH:MM:SS A/P

I'm having a problem when editing the field after the info is written to the databse.
It's written in the correct format

DD/MM/YYYY HH:MM:SS A/P

When I try to pull the info from the database I come into problems in
achieving what I need. If I use the following coding

<%= DoDateTime((rsAllAds.Fields.Item("AD_DATED".Value), 0, 4105) %>

the data is displayed correctly.
If I try to edit the info while in this format, the page crashes.

If I used this format
<%=(rsAllAds.Fields.Item("AD_DATED".Value)%>

the the date is written in the field as
MM/DD/YYYY HH:MM:SS A/P
and the page does NOT crash on update

I need to edit the info in the DD/MM/YYYY HH:MM:SS A/P format

What can I do?

All help is apreciated
Thanks