Re: Date format frustration in forms

It may be the Windows regional setting is in American format. Change
the regional setting to Dutch & make sure the date format is correct in
the regional setting.

I have similar problem long time ago as we use Australian format. But
the IT guys always forgot to change the regional settings when
installing new PCs. I'm now having code to check the date format in the
startup form.

I hope that will help.

Cheers,
Ray

.

Relevant Pages

  • Re: Date setting - newbie
    ... But how come I get conversion error if I update/insert a record using ... I've checked my Regional setting and it's in ... > Some formats are dependent on SQL Server settings such as SET DATEFORMAT, ... the date is not returned in any format when it leaves SQL ...
    (microsoft.public.sqlserver.server)
  • RE: If Statement Problem
    ... have this setting in the regional setting for the hour format. ... fetched have from <13:00 then is normal that the field text6 is set to no and ... HTH Paolo ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dates
    ... > Dim a As String ... then there is no way for you to know what regional setting ... "standard" format for your date storage. ...
    (microsoft.public.vb.enterprise)
  • Re: Stored Procedure Date Parameter Conversion
    ... This corrected the format, but it's still producing the same result. ... single quotes around the date in Access and pass it via the parameter. ... but I'm getting an inconsistent data types ... You might also want to try out by setting your OS Regional Setting in the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Date format cannot be controlled
    ... database can be downloaded for free at ... >I have an unbound form ... > My regional setting are definately UK english and my short date format ... same as the format for the unbound control. ...
    (comp.databases.ms-access)
Loading