Date Format

[davidwdf]

I'm pulling my hair out! When I import a date from Excel I get 1904 instead of 2004. What's up? Please help.Oh yea, I'm running FM6

thanks

[SteveB]

You most likely have a two-digit year in your Excel Dates. Two options: correct the Excel dates or add 100 years after you do the import.

Steve

[Steve T.]

Yeah.. FM has a 2-digit year guessing system but it does not apply to imported data; only data directly typed in (I was bummed when I read that). Go w/4 digit years whenever possible.

--ST