Date question 1

[jlg5454]

How do I format a string dd-mmm-yy to a date format mmmm yyy?
Thanks,

 

[jebry]

Hi!

Try Format(CDate(YourString), "mmmm yyy")

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[jlg5454]

Thanks for your help. I think what the problem is that my date field is text and is shown for example as "09-JAN-06". I need this to read in date format as January 2006. Thanks for any help you can provide

 

[Golom]

Then you want

Format(CDate(YourString), "mmmm yyy[COLOR=red]y[/color]")

The "yyy" format gives you the last two digits of the year followed by the day number in the year. For example, today is "06123".

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[jlg5454]

Thank you! It worked. I thought yyy and yyyy provided the same results.

 

[jebry]

Thanks Golom!

I just got back to this and see that you helped! We worked as a tag team on this one!!



Jeff Bridgham
Purdue University
Graduate School
Data Analyst