Hello.

A weird one - wondered if anyone has come across this.

Usually when using isdate function it tells me whether the string/number sent to it is a date.

Appeared to work fine.

However now it is not working fine and I cannot see why.

I'm pulling data from Excel which is in a date format, but not a proper date (I think). I change the cell formatting to text (via number format and '@')
and the contents change to a number. Ah ha. IsDate should work. It doesn't.

Just so people can check to see if maybe something is corrupted/running wrong here...
The date, number
24/08/1971 , 26169

If any one has come across this and knows how to fix Access VBA to work, please let me know. For now I'm going to use the format function which (for some reason) is changing the value to a date correctly.

Thanks in advance