Date format (Resolved)

[Iat]

Hi,
With this line of code

Text2.Text = Format(Now, "yyyy mm dd hh:mm:ss")

The output looks like this but...

2004 03 11 19:07:58

I want to get the output to display "03" as "Mar" like the one below

2004 Mar 11 19:07:58

Can it be done?

Thanks,

[Bruce Fox]

With an extra "m" like:

Format(Now, "yyyy mmm dd hh:mm:ss")

Bruce.

[Iat]

Thanks, that's exactly what I needed.

[Bruce Fox]

No problem

This function may also come in handy one day:

FormatdateTime()

It has the following syntax:

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).

Bruce.