Re: datetime help from usa to iso

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

why do i do that!!

thanks for the help everyone,
i appreciate it.

thanks,
rod.

"Göran Andersson" wrote:

rodchar wrote:
ok, that worked,
however,
once i got it into:
varDate.ToString("yyyy/MM/dd")

i did this:
varDate.ToString("yyyy/MM/dd").SubString(5,2)
to extract the month. was that the best way?


No, that's not the best way. You can for example change the formatting
string to only include the month:

varDate.ToString("MM")

--
Göran Andersson
_____
http://www.guffa.com

.

Relevant Pages

  • Re: Track Changes VBA Granular information needed
    ... If the second string occurs somewhere in the first ... Bold, Italic". ... If you're keeping separate track of bold formatting and italic ... extract more specific changes. ...
    (microsoft.public.word.vba.beginners)
  • Re: Extract Digit Function Question
    ... Function ExtractDigits(cell As String) As Variant ... 'extract 1st continuous set of digits ... > and formatted your cell not to show decimal places. ... > by the formatting of the cell. ...
    (microsoft.public.excel.programming)
  • Re: Char String to Matrix
    ... <SNIP wants to extract numbers from an awful string... ... % the string ... % assume simple number formatting(!) only ...
    (comp.soft-sys.matlab)
  • Re: Char String to Matrix
    ... <SNIP wants to extract numbers from an awful string... ... % the string ... % assume simple number formatting(!) only ...
    (comp.soft-sys.matlab)
  • what type of code is this?
    ... but i need to read a csv file that contains information about different concerts and events... ... Dim Data As String ... I need to search within the group of csv files and extract data into an Excel ...
    (microsoft.public.excel.programming)