ACCESS FEED: RE: [MS_AccessPros] DateSerial formatting

Rabu, 03 April 2013

RE: [MS_AccessPros] DateSerial formatting

Sorry about that – I must have stuttered on the "d" key :-)

As you can see, the number of "d"s (or "m"s or "y"s) can have a marked
effect in the result!

I'm glad you got it working.

Cheers,
Graham

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ghsclass65
> Sent: Thursday, 4 April 2013 07:24
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] DateSerial formatting
>
>
> Graham,
>
> I deleted the extra "d" at the beginning of your suggestion, and all is
well. Thanks.
>
> Russ
>
> --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno"
<graham@...> wrote:
> >
> > Hello Russ
> >
> > There is no need to change your regional settings. Indeed, it is highly
> > possible that you will want to display dates two or more different ways
in
> > the same application, or even in the same form or report!
> >
> > Instead, use the Format property of the textbox containing the date. For
> > the format you describe, you will need to set this property to:
> >
> > ddddd, mmmm d, yyyy
> >
> > The single "d" denotes a single digit date for days less than 10.
> >
> > For other info on the many formatting options, and what the pattern
strings
> > mean, check out the online help.
> >
> > Best wishes,
> > Graham [Access MVP 1996-2013]
> >
> >
> > > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ghsclass65
> > > Sent: Thursday, 4 April 2013 05:14
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] DateSerial formatting
> > >
> > >
> > > Thanks Darrell
> > >
> > > Russ
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Embrey, Darrell"
> > <DEmbrey@> wrote:
> > > >
> > > > That's from your Region and Language settings for Windows Control
Panel.
> > You can make the change there.
> > > >
> > > > Darrell
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ghsclass65
> > > > Sent: Wednesday, April 03, 2013 11:48 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] DateSerial formatting
> > > >
> > > >
> > > >
> > > > I've got a date field formatted as a Long Date field. With this
> > expression
> > > >
> > > >
> >
=DateSerial(Year(Date()),Month(Date())+1,1)+7-Weekday(DateSerial(Year(Date()
> > ),Month(Date())+1,1),2)
> > > >
> > > > it will show a single digit date like this for example.
> > > >
> > > > Sunday, May 05, 2013
> > > >
> > > > Is there a way to change this so it will display a date in the
following
> > format?
> > > >
> > > > Sunday, May 5, 2013
> > > >