FormatDateTime

[gdshih]

I am trying to format a date from 4/27/2012 to April 27, 2012. When I use vbLongDate, it also gives me the day of the week in front, which looks like Friday, April 27, 2012. Is there any way to get rid of the day of the week?



Thanks

[Richie27]

Funny - I had something like that earlier today - you should find your answer here - http://office.microsoft.com/en-us/ac...001228839.aspx

[gdshih]

Thanks for the response.

I am very new to vba code so reading over that article just made me a little more confused..

[ketbdnetbp]

You could try:
Forms -
[Forms]![YourFormName]![DateField].format = "mmmm d yyyy"

Or
Vba -
dim dte1 as date
dte1 = Format(YourDate,"mmmm d yyyy")

and see if this gets the desired results.

Jim