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.


---
Message posted from http://www.ExcelForum.com/

Hi neowok!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"neowok " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

In VBA, DATE is equivalent to Today in the worksheet

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

--
Regards,
Tom Ogilvy


"neowok " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

nice that worked.

thank

--
Message posted from http://www.ExcelForum.com