Jump to content

Has anyone else experienced this glitch?


 Share

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

Recommended Posts

In one of my databases I have one date field that no matter what I do, displays the date as dd/mm/yyyy. I have tried to change it in Date Format to mm/dd/yyyy, nothing works! Has anyone else had this type of problem? What did you do?

-Kate

Link to comment
Share on other sites

That was a great suggestion, but it was correctly defined as United States when I checked it. I really thought that you had it there!! I don't know, it doesn't make sense why the date would change in one file, one field!!

Link to comment
Share on other sites

What happens if you save a clone of the file with "No Records" and then import the current file into it. Does it have an effect on the date structure then? You could do this with just a sample of the current file (4 or 5 records).

Lee

wink.gif

Link to comment
Share on other sites

Hi Kate,

Glad it worked.

This is a workaround that is used to change the System data when a file is created on a different country version of filemaker than the one you are using. Just changing or using the "Set Use System Formats script step" doesn't change the date format unless you have an empty file (I can't tell you why), and I hope that this is changed in version 7.

Lee

Link to comment
Share on other sites

Ahhh....I see. Thanks for explaining that. No, it doesn't make sense why an empty file was needed to make the format change. I'm just really glad that I now know a workaround if something like that happens again. Thanks again!

Kate

Link to comment
Share on other sites

This topic is 6555 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.