I have what I think might be an easy one, but it's driving me mad.
I'm trying to split this date on the " "
Here's the date: "11/14/2009 1:00:00 PM "
Below is the code that I'm using - for some reason I can only get the first value when I call the array that I've created using START_TIME(0)
I'm really in a bind, and need to split the date above, pull out the actual time and remove the extra :00 from the end of it.
I'm awarding extra points because I'm up against a wall. THanks!!
pre_start = rs("BEGIN_DATE_TIME")
START_TIME = Split(pre_start)