Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Format Date #/#/#

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  space between columns  
Author Message
NikkiB

External


Since: Jan 15, 2009
Posts: 2



(Msg. 1) Posted: Thu Jan 15, 2009 11:05 am
Post subject: Format Date #/#/#
Archived from groups: microsoft>public>access (more info?)
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 results.

The function I am trying to use is:
CVDate(Format([LSAB_FIRST_CYMD],"####/##/##")) but it keeps automatically
changeing my format value to the following:
CVDate(Format([LSAB_FIRST_CYMD],"#\/#\/#"))

Any suggestions would be greatly appreciated.

Thank you for your time,
Nikki

 >> Stay informed about: Format Date #/#/# 
Back to top
Login to vote
Douglas J. Steele

External


Since: Nov 27, 2008
Posts: 61



(Msg. 2) Posted: Thu Jan 15, 2009 2:11 pm
Post subject: Re: Format Date #/#/#
Archived from groups: per prev. post (more info?)
Try

"yyyy\/mm\/dd"

 >> Stay informed about: Format Date #/#/# 
Back to top
Login to vote
NikkiB

External


Since: Jan 15, 2009
Posts: 2



(Msg. 3) Posted: Thu Jan 15, 2009 2:11 pm
Post subject: Re: Format Date #/#/#
Archived from groups: per prev. post (more info?)
Thanks for the input but that didn't work either. But...OMG! for some reason
when I JUST typed "####/##/##" it worked this time!

I have no idea why it was getting tripped up before but I'm happy to see it
is working correctly now. I guess I will close this mysterious post.

I appreciate your time.

Nikki

"Douglas J. Steele" wrote:

> Try
>
> "yyyy\/mm\/dd"
>
> --
> Doug Steele, Microsoft Access MVP
> [URL="http://I.Am/DougSteele"]http://I.Am/DougSteele[/URL]
> (no e-mails, please!)
>
>
> "NikkiB" wrote in message
>
> >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 results.
> >
> > The function I am trying to use is:
> > CVDate(Format([LSAB_FIRST_CYMD],"####/##/##")) but it keeps automatically
> > changeing my format value to the following:
> > CVDate(Format([LSAB_FIRST_CYMD],"#\/#\/#"))
> >
> > Any suggestions would be greatly appreciated.
> >
> > Thank you for your time,
> > Nikki
> >
> >
> >
> >
> >
>
>
>
 >> Stay informed about: Format Date #/#/# 
Back to top
Login to vote
Douglas J. Steele

External


Since: Nov 27, 2008
Posts: 61



(Msg. 4) Posted: Thu Jan 15, 2009 6:44 pm
Post subject: Re: Format Date #/#/#
Archived from groups: per prev. post (more info?)
Is LSAB_FIRST_CYMD a Date field, or is it strictly a Text field you're
trying to format as a date?

If it's a date field, you definitely should have the yyyy, mm and dd there.
If it's a text field, # is all you need.
 >> Stay informed about: Format Date #/#/# 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Date Format - how can i set the date format from 8/30/2009 to August, 2009?? This date is on my subform. any idea?

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



[ Contact us | Terms of Service/Privacy Policy ]