Format(Date, "???") what if I want the date in long form? 1

[JaeBrett]

I usually use "MM/DD/YYYY" but now I want to switch for it to say "November 3, 2003". How do I do this?

 

[DrJavaJoe]

Try MsgBox Format(Date, "Long Date&quot

 

[DrJavaJoe]

Or
MsgBox Format(Date, "mmmm d, yyyy&quot

 

[vb5prgrmr]

or better yet...
[tt]
MsgBox FormatDateTime(Date, vbLongDate)
[/tt]

Good Luck

 

[vb5prgrmr]

Ok, well maybe not better but that is what the function is for...
[tt]
FormatDateTime Function


Description

Returns an expression formatted as a date or time.

Syntax

FormatDateTime(Date[,NamedFormat])

The FormatDateTime function syntax has these parts:

Part Description
Date Required. Date expression to be formatted.
NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.


Settings

The NamedFormat argument has the following settings:

Constant Value Description
vbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.

vbLongDate 1 Display a date using the long date format specified in your computer's regional settings.

vbShortDate 2 Display a date using the short date format specified in your computer's regional settings.

vbLongTime 3 Display a time using the time format specified in your computer's regional settings.

vbShortTime 4 Display a time using the 24-hour format (hh:mm).
[/tt]

Good Luck

 

[vb5prgrmr]

JaeBrett,

Did any of this help you???

 

[JaeBrett]

I had to throw this project on the back-burner for a few days. I just tried Format(Date, "mmmm d, yyyy&quot and it's what I needed.

Merci!