Thursday, June 26, 2008

Weird @TextToTime Behavior

This isn't really a Show-n-Tell Thursday post, even though it is Thursday. I'm having a problem with a @TextToTime formula and I can't find any documented reason why. When I pass it the string "R. Marshall" it returns 3/1/2008. In fact, if I pass it "Ma", it returns that date. As long as it doesn't have "ma" at the start of any word in the string, it returns nothing (which is what I'd expect).

Has anyone else seen that? Can you duplicate it?

1 comment:

Nate said...

it's trying to loosely interpret "Ma" as "March".

I bet you'd get something interesting with "Ja" or "Fe" too.