Posted to microsoft.public.excel.programming

external usenet poster

Posts: 399

Change date format in string?

I have a macro which AutoFilters a date column. The spreadsheet is now
being created differently, and the dates are coming up in a different
format. Currently, I have
If MyTarget = "d" Then
Selection.AutoFilter Field:=5, Criteria1:="=20020703", _
Operator:=xlAnd, Criteria2:="<=20030616"
End If

Is there any way to change these dates to "03-Jul-02" on the fly? Or do I
need to go into the macro and redo the date for every If?

Ed

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
Convert Date string to date format	Joe M.	Excel Discussion (Misc queries)	7	May 6th 10 02:46 PM
change a string of numbers in to number format	Debi	Excel Worksheet Functions	1	December 7th 06 05:15 PM
Date format in string	Adam Thwaites	Excel Discussion (Misc queries)	3	May 10th 06 04:14 PM
Change a date in text format xx.xx.20xx to a recognised date format	concatenator	Excel Programming	1	November 24th 03 11:33 PM
convert a string of into a date format	Fred[_12_]	Excel Programming	2	August 14th 03 11:56 PM

All times are GMT +1. The time now is 04:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us