Rabu, 03 April 2013

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
> > >
> > >
> > >
> > > The information contained in this communication is highly confidential
> and is intended solely for the use of the individual(s) to whom this
> communication is directed. If you are not the intended recipient, you are
> hereby notified that any viewing, copying, disclosure or distribution of
> this information is prohibited. Please notify the sender, by electronic mail
> or telephone, of any unintended receipt and delete the original message
> without making any copies.
> > >
> > > Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are
> nonprofit corporations and independent licensees of the Blue Cross and Blue
> Shield Association.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar