Date Format

FAQ

Profile

Date Format

Windows Help (Home) -> Microsoft Access

Next: RDC issue with Dell Latitude D630 units

Author

Message

ghostman via AccessMonste

External

Since: Aug 8, 2009
Posts: 2

(Msg. 1) Posted: Sat Aug 08, 2009 4:25 am
Post subject: Date Format
Archived from groups: microsoft>public>access (more info?)

how can i set the date format from 8/30/2009 to August, 2009??
This date is on my subform.

any idea?

>> Stay informed about: Date Format

Wayne-I-M

External

Since: Dec 23, 2008
Posts: 10

(Msg. 2) Posted: Sat Aug 08, 2009 4:25 am
Post subject: RE: Date Format
Archived from groups: per prev. post (more info?)

Hi

Set the format (in design view) to

mmmm", "yyyy

>> Stay informed about: Date Format

John W. Vinson

External

Since: Nov 28, 2008
Posts: 104

(Msg. 3) Posted: Sat Aug 08, 2009 1:25 pm Post subject: Re: Date Format Archived from groups: per prev. post (more info?)

On Sat, 08 Aug 2009 07:41:02 GMT, "ghostman via AccessMonster.com" wrote: >how can i set the date format from 8/30/2009 to August, 2009?? >This date is on my subform. > >any idea? A Format property of mmmm, yyyy should do the job. Dig down (several levels!!) in the online help for custom date formats; they are very flexible (e.g. m is 8, mm is 08, mmm is Aug, mmmm is August; there are formats for everything from seconds to years). >> Stay informed about: Date Format

ghostman via AccessMonste

External

Since: Aug 8, 2009
Posts: 2

(Msg. 4) Posted: Mon Aug 10, 2009 3:25 am Post subject: Re: Date Format Archived from groups: per prev. post (more info?)

thanks a lot John & Wayne John W. Vinson wrote: >>how can i set the date format from 8/30/2009 to August, 2009?? >>This date is on my subform. >> >>any idea? > >A Format property of > >mmmm, yyyy > >should do the job. Dig down (several levels!!) in the online help for custom >date formats; they are very flexible (e.g. m is 8, mm is 08, mmm is Aug, mmmm >is August; there are formats for everything from seconds to years). >> Stay informed about: Date Format

Display posts from previous:

Related Topics:

Format Date #/#/# - I am trying to use a function that I have used in the past but for some reason today when I type it in the query field and run my report Access is converting "####/##/##" to #\/#\/# and I receive an error message in that field for my query r...

Custom Date Format - How do I create a date format? I need the format to be: YYYYMMDD. Thanks

date format - excluding year - Hello again - I'm having trouble entering dates without the year. I want to keep the year in a separate column (so I can sort or filter by year). I know I should be able to format it using dd-mmm, but as soon as I export it to Excel, 2009 is ..

MM/DD date format no year - Hi, Is there a way to format the input for a date field using only the month and day. I have a program where I input data for a given year and don't want to enter the year with every date input. Thanks,

Automate Change of the format of a field to short date for.. - Hi, I have a table that I am creating through a make table query. Once created, I want to export the table to a text file and save to a location. I am attempting to create a macro that will do this. One of my fields is called CMMonth. The problem i...

	Windows Help (Home) -> Microsoft Access	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum