converting 'TODAY' into dd-mmm-yy format

  • Thread starter Thread starter neowok
  • Start date Start date
N

neowok

I have the following code which converts some textbox text into the
format i need

mydatestr = Format(CDate(TextBox2.Text), "dd-mmm-yy")

what i also need is to get todays date and put that into the same
format as well but substituting textbox2.text for TODAY doesnt seem to
work.
 
Hi neowok!

Use:
mydatestr = Format(Date, "dd-mmm-yy")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
In VBA, DATE is equivalent to Today in the worksheet

mydatestr1 = Format(CDate(Date), "dd-mmm-yy")
 
Back
Top