View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RG III RG III is offline
external usenet poster
 
Posts: 65
Default Find position of date in string


Const myStr = "The video shows that on 9/24/2019 the suspect entered
the store."

i = InStr(myStr, "/")
myPos = InStrRev(myStr, " ", i) + 1



I suppose that works. It appears to just find the first "/" character
in a string, is that right?

And BTW, I made a typo in my above message. The format of the
dates is "m/dd/yyyy" or "mm/dd/yyyy".