Using Instr

[keith0528]

Greetings All,

I'm trying to use instr to isolate the day part of a date

Dim BegDate As String
BegDate = Range("B3").Value
modBegDate = InStr(1, BegDate, ? )


the value in BegDate is "3/1/2014 3:35:09 PM" What I want to isolate is the day "01"

Question - the value in cell B3 is format type Custom. Does that make a difference?

thank you

 

[mikerickson]

I would look for the "/" Instr(1, BegDate, "/") will return the position of the first "/".

Alternatly, have you considered Dimming BegDate as Date and using modBegDate = Day(BegDate)

If begDate has to be a string you could use modBegDate = Day(DateValue(BegDate))

 

[npvrader]

Is the value in range "B3" a string or is it really a date value?

 

[Rick Rothstein]

I would look for the "/" Instr(1, BegDate, "/") will return the position of the first "/".

Alternately, you could use the Split function...

modBegDate = Split(BegDate, "/")(1)

 

[mirabeau]

=Day(Int(BegDate))

 

[keith0528]

thanks All,

MikeR and Rick R. Both of those solutions give me what i needed.

thank you.