Leb i Sol Posted March 25, 2004 Share Posted March 25, 2004 Hello People! I could sware I saw some posts about date issues and now are nowhere to be found on the forums....but perhaps I dream about it. In any case, I get an odd FM result when importing data from CSV file. In CSV file mu "date field" is in format of mm/dd/yyyy and "date field" in FM accepts it fine but the "2yk -like" issue appears where FM field is defined as DATE 1/22/2001 is imported as 1/22/1901 if I define the field (in FM) as TEXT or NUMBER it imports year in 2 digit 1/22/2001 is imported as 1/22/01 FM is updated and auto-entry into date fields is in correct format...it is only the import that troubles me. Any advice is apprechiated! many thanx! Version: v6.x Platform: Windows 2000 Link to comment Share on other sites More sharing options...
Vaughan Posted March 25, 2004 Share Posted March 25, 2004 "In CSV file mu "date field" is in format of mm/dd/yyyy " Are you sure? What program are you viewing the CSV data in? Excel has a tendency to modify data without asking or notifying, best use a simple text editor like Note Pad. Link to comment Share on other sites More sharing options...
Leb i Sol Posted March 25, 2004 Author Share Posted March 25, 2004 Hey Vaughan! Thanx for the tip...ur were right....when viewd in notepad the actual date is in format of dd/mm/yy strange, I never knew about excel "auto-twisting" the output. Works for me! Thanx! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7479 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 accountSign in
Already have an account? Sign in here.
Sign In Now