Posted to microsoft.public.excel.programming

neowok[_24_] neowok[_24_] is offline

external usenet poster

Posts: 1

converting 'TODAY' into dd-mmm-yy format

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with converting CUSTOM format/TEXT format to DATE format	Deo Cleto	Excel Worksheet Functions	6	June 2nd 09 08:14 PM
Conditional Format <=Today()	Matt D Francis	Excel Worksheet Functions	0	March 28th 07 02:46 AM
Conditional Format <=Today()	Marcelo	Excel Worksheet Functions	0	March 28th 07 02:45 AM
MM/DD/YYYY format Today	Glenda	Excel Discussion (Misc queries)	1	February 21st 06 03:51 PM
Custom Format for WEEKNUM(Today())	RonB	Excel Discussion (Misc queries)	2	January 12th 05 06:13 PM

All times are GMT +1. The time now is 09:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us