Thread
:
converting 'TODAY' into dd-mmm-yy format
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Harker
external usenet poster
Posts: 162
converting 'TODAY' into dd-mmm-yy format
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/
Reply With Quote
Norman Harker
View Public Profile
Find all posts by Norman Harker