🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #227

Re: newbie question I - Date fields / input mask & regional settings

#227
From: Birthe Weidinger
Date: Thu, 31 May 2001 08:02
23 lines
1991 bytes
Try to set the fields format to the format you want ex. dd-mm-yy (shown as
31-05-01)

Birthe.

"Henning Lang" <hlang@myrealbox.com> skrev i en meddelelse
news:e6pP6.1$rB3.244@news010.worldonline.dk...
> In all my tables and forms I've defined my date fields with a input mask
of
> 00 in the year fields. This works out fine except in one situation. On the
> pc's where the application is to be used, the regional settings are
defined
> as yyyy as the year and therefore the "output" on the forms get showns as
> yyyy. The problem is that when a user edits one of the date fields and
> changes the month field they will also have to change the 2001 year to 01
to
> make it obey the input mask. Is there any workaround to this problem.
>
>
> Henning Lang
> hlang@myrealbox.com
>
>
Technical Details
Message-ID: <9f4tn4$fvb$1@news.inet.tele.dk>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!news.tele.dk!TDC-Europe.POSTED!193.89.229.143!not-for-mail
References: <e6pP6.1$rB3.244@news010.worldonline.dk>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,f78daa5b0298dc2f
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11387c,f78daa5b0298dc2f
X-Google-Attributes: gid11387c,public
X-Google-ArrivalTime: 2001-05-31 01:00:37 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!news.tele.dk!TDC-Europe.POSTED!193.89.229.143!not-for-mail
From: "Birthe Weidinger" <birthe@unibase.dk>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access
Subject: Re: newbie question I - Date fields / input mask & regional settings
Date: Thu, 31 May 2001 10:02:03 +0200
Organization: Posted through some European Outpost of TDC Internet A/S
Lines: 25
Message-ID: <9f4tn4$fvb$1@news.inet.tele.dk>
References: <e6pP6.1$rB3.244@news010.worldonline.dk>
NNTP-Posting-Host: 193.89.229.143
X-Trace: news.inet.tele.dk 991296036 16363 193.89.229.143
X-Complaints-To: the appropriate department of the poster's provider
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700