K kacey8 Registered User. Local time Today, 19:42 Joined Jun 12, 2014 Messages 180 Jul 2, 2014 #21 pbaldy said: I just noticed the format. Try "mm\/dd\/yyyy" VBA expects dates in US format: http://allenbrowne.com/ser-36.html#Format Click to expand... You Good Sir are a damn miricle worker. Works flawlessly I owe you more than a few beers
pbaldy said: I just noticed the format. Try "mm\/dd\/yyyy" VBA expects dates in US format: http://allenbrowne.com/ser-36.html#Format Click to expand... You Good Sir are a damn miricle worker. Works flawlessly I owe you more than a few beers
pbaldy Wino Moderator Staff member Local time Today, 11:42 Joined Aug 30, 2003 Messages 36,157 Jul 2, 2014 #22 Happy to help! I was surprised I missed that but you had it correct in earlier code. You must have changed it at some point.
Happy to help! I was surprised I missed that but you had it correct in earlier code. You must have changed it at some point.
K kacey8 Registered User. Local time Today, 19:42 Joined Jun 12, 2014 Messages 180 Jul 2, 2014 #23 I did.... My bad.. I changed it because being in the UK everything normally displays in DD/MM/YYYY so I just adjusted it to fit, never thought it'd be an issue.
I did.... My bad.. I changed it because being in the UK everything normally displays in DD/MM/YYYY so I just adjusted it to fit, never thought it'd be an issue.
