showing days of the week from the date
in [Forms]
|
From: Twb on 27 Apr 2010 11:32 I would like to show the day of the week based of the date e.g. 27th April 2010 - Tuesday, is this possible? please help. Many thanks
From: Nigel on 27 Apr 2010 11:41 If the date is displayed on a form, select the properties of the control and change the format to dddd. "Twb" wrote: > I would like to show the day of the week based of the date e.g. 27th April > 2010 - Tuesday, is this possible? please help. > > Many thanks
From: Dirk Goldgar on 27 Apr 2010 11:44 "Twb" <Twb(a)discussions.microsoft.com> wrote in message news:7E3A0950-009B-4330-AD8F-C6B7B303AA0B(a)microsoft.com... >I would like to show the day of the week based of the date e.g. 27th April > 2010 - Tuesday, is this possible? please help. In VBA code or a calculated field in a query, you can use the Format function: ?Format(Date, "mmmm d, yyyy - dddd") April 27, 2010 - Tuesday In a text box, you can use a similar Format property: mmmm d, yyyy - dddd Access will probably transform that to this: mmmm d", "yyyy - dddd but it will still work. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup)
From: John W. Vinson on 27 Apr 2010 12:32 On Tue, 27 Apr 2010 08:32:03 -0700, Twb <Twb(a)discussions.microsoft.com> wrote: >I would like to show the day of the week based of the date e.g. 27th April >2010 - Tuesday, is this possible? please help. > >Many thanks Sure. You can use a Format for the date including the day name. For instance you can use a textbox on a form with a control source =Date() or bound to a date/time field in your table. To get almost the exact appearance you describe (without the 'th' which will take some VBA code) set the textbox's Format property to "dd mmmm yyyy \- dddd" The dd format option gives the numeric day; ddd gives the three letter day abbreviation (Tue), dddd the full day name (Tuesday). I'm pretty sure you can find some code for the ordinal numbers (1st, 2nd, etc.) at http://www.mvps.org/access - search for "ordinal". -- John W. Vinson [MVP]
From: Twb on 29 Apr 2010 05:25
thanks "Dirk Goldgar" wrote: > "Twb" <Twb(a)discussions.microsoft.com> wrote in message > news:7E3A0950-009B-4330-AD8F-C6B7B303AA0B(a)microsoft.com... > >I would like to show the day of the week based of the date e.g. 27th April > > 2010 - Tuesday, is this possible? please help. > > > In VBA code or a calculated field in a query, you can use the Format > function: > > ?Format(Date, "mmmm d, yyyy - dddd") > April 27, 2010 - Tuesday > > In a text box, you can use a similar Format property: > > mmmm d, yyyy - dddd > > Access will probably transform that to this: > > mmmm d", "yyyy - dddd > > but it will still work. > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) > |