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".
|