How to format the =Now() to a specific format in VB

[arneym]

Hello All,

I am creating a button to generate a date/time stamp as the form number. I need it to generate YYMMDD-HHMM


I am not having any luck. Please HELP!!

[redbull]

I found this helpful link...

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Looks like


("yy mm, dd")

"MM"

The month, from 01 through 12. More information: The "MM" Custom Format Specifier.

6/15/2009 1:45:30 PM -> 06

"yy"

The year, from 00 to 99. More information: The "yy" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 01 1/1/0900 12:00:00 AM -> 00 1/1/1900 12:00:00 AM -> 00 6/15/2009 1:45:30 PM -> 09

"dd"

The day of the month, from 01 through 31. More information: The "dd" Custom Format Specifier.

6/1/2009 1:45:30 PM -> 01 6/15/2009 1:45:30 PM -> 15

[JoeM]

Try:

Format(Now(), "yymmdd-hhmm")

[redbull]

Sorry

=Now("yy mm, dd - HH MM ")

"HH"

The hour, using a 24-hour clock from 00 to 23. More information: The "HH" Custom Format Specifier.

6/15/2009 1:45:30 AM -> 01 6/15/2009 1:45:30 PM -> 13

"MM"

The month, from 01 through 12. More information: The "MM" Custom Format Specifier.

6/15/2009 1:45:30 PM -> 06

[arneym]

Try:

Format(Now(), "yymmdd-hhmm")

Thank you, JoeM!!
This produced exactly what I was asking for!!

Code:
Private Sub btnDateTime_Click()
Me.txtDateTime = Format(Now(), "YYMMDD-HHMM")


End Sub

[arneym]

Thank you, redbull!

I appreciate your help.