Jump to content

01 dates importing as 1901


 Share

This topic is 7249 days old. Please don't post here. Open a new topic instead.

Recommended Posts

First, be sure that you are using a Y2K compliant version of FMP, namely 4.0v3, 4.1v3, 5.0vx, or 5.5vx. There may also be an updater for FMP3 as well.

That said, the easiest wau to address this is to alter the text file before it is imported so that the dates are explicitly 2001.

HTH

Old Advance Man

Link to comment
Share on other sites

I've got a txt file that I import into FM4 which includes a field in mm/dd/yy format. It is being imported into a table witht the date field set to format as mm/dd/yyyy. The current year is showing as 1901. Any ideas what I have to do so that it imports it reflecting the proper year.

TIA

Alain

Link to comment
Share on other sites

This topic is 7249 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.