Access og Dato format

Access2000: yyyy-mm-dd returnerer: 2002-02-26
Access97  : åååå-mm-dd returnerer: 2002-02-26

Mår jeg gemmer mit format fra formular er så US format 2/26/2002 står i database som 20020226
Mår jeg henter fra databas så får jeg 26-02-2002 jeg ønsker at få 2/26/2002
?????????

mm-dd-yyyy

yes

Access date formats are controlled by the regional settings (how they are viewed) So if you want to see them in US format (MM-DD-YYYY) then you need to alter your regional settings or use the format function to show them as you want!

The database stores the actual date as big number and it uses the regional settings to control how it will be shown. So if your in DK (regional settings) it will show DD-MM-YYYY and in the US MM-DD-YYYY

So change your regional settings!

jorn1 > Hvis "yes" betyder at skidtet fungerer, så kan vi vel afslutte spørgsmålet!

til MUGS  nej skittet fungere ikke,

To Terry.

My server is set up with regional settings to US format, and problem is when i write to the database ny date is corect bout whwn y read from the database my date shows in danish format.

US format mm/dd/yyyy
Danish format dd-mm-yyyy
if you will test it your self
www.c-house.dk/maxweb
and login as guest guest, clik on a date on the calender and add a event, then tray to edit the event and on this page the date is wronk

Hvis ikke du angiver et format for datoen, vil du få formattet angivet på Serveren's internationale indstillinger i kontrolpanel. Uanset hvad Access er sat op til.
Når du skriver til databasen SKAL du bruge formattet mm-dd-yy eller yyyy-mm-dd hvilket skyldes SQL sproget.

I Access kan en textbox's format angives til format([dateField],"mm/dd/yyyy") - Hvordan du anvender format functionen i ASP eller hvad du progamere i ved jeg ikke.

Dette er en uddybning af Terry's indlæg.

Niels

Forkert
'Serveren's internationale indstillinger i kontrolpanel'

Det er Pc'ens indstillinger, altså den der læser datoen.

Niels

jorn1 -> Jeg har lige prøvet at editere i din kalender med mine indstillinger sat til US - Og så er formattet som du vil have dem.

Det er op til den maskine der læser datoen, hvordan datoværdien skal oversættes/formateres.

Niels

det er ikke et program jeg har lavet men angivet fra programøern at det kun kan bruges med US format altså at servern er sat op til regional settings til engelsk US, jeg køre min egen server så det burde jo ikke være moget problem, HI HI jeg kan bare ikke få det L*** til at virke

jorn1> Dates almost always gives problems!
I didnt realise that we were talking about a WEB application until you placed the link to your WEB.
The servers regional settings is used to return a date form the database. But you have to save the database in the correct format (at the client) or it MAY be saved in the database incorrectly and will NOT be shown correctly.

IF you save the date in YYYY-MM-DD format then it will get saved correctly but you have to ensure that the date IS in the correct format

For example: 11/12/2002 Is that 11 December or 12 November 2002?

I just added an event and set the end date to 2/28/2002 and it was OK
but if I used 28/02/2002 the it gets converted incorrectly to 2/2/2029

So some how you need to check the date BEFORE you write it to the dB.

Oh! Your web looks very nice :o)

when you write a event that is ok and it is saved in db in text format 20020226000000 ( for the date 2/28/2001 ) and is apper in the calender on the right date. First when you will edit then the wrong date apper in the form and most be writen on the corect way, so maybe i have to look on the comant line who is callling for this date. In this line is some command (server.HTMLEncode) can you explain this code

thanks in advance

jorn1> I dont know much at all about web programming, I have worked with ASP and VB Script not Java so I dont think I can explain server.HTMLEncode!

Is the date in the database a text field?

I have JUST made an event. The start AND end date was 2/26/2002. I edited the end date to 2/28/2002
If YOU click on the event in the calendar youcan see that the date IS displayed correctly. So a slong a sthe date is entered (edited) in MM-DD-YYYY format there IS no problem. BUT if you enter the date in Danish format then you have a problem.

jorn1>hows it going here?