Quote Originally Posted by Dave View Post
Remove the location and 1900 problem by replacing the date entry and retrieval with strings. Dave

Agree - not sure why this is a separate thread?????

http://www.vbaexpress.com/forum/show...ly-Interpreted

I've only been looking at the Date part

However, the interpolation (if that's what's going on) to guess an enlistment date based on the input and two surrounding soldier numbers would have to be done using the VBA dates