Baffled by date problem.

[Tearose]

We're using FMP 5.5. We're trying to put dates in a text field, importing from a .csv file. In the .csv the dates are given yyyy/mm/dd. When I imported them they seemed to be in that order. After I closed and reopened it, they were yyyy/dd/mm. Why is it switching the day and month?
Jill

 

[Tearose]

I just double checked, and only a few of them had, and still have the correct order. the rest have a reversed month and day. Is something causing them to be formatted the way they were on a previous attempt to import them. Since it's a text field, and not a date field, I don't understand why it won't import them just they way they are in the .csv file.

 

[Tearose]

Mea Culpa! It turns out it was "the nut behind the wheel", not FMP. The .csv file was sent to me by a volunteer who had accidentally forgotten not to use Excel to edit the dates- it closed up the spaces in the match field, so the correct dates weren't being entered, except in the instances where there were no spaces in the field to begin with. Those were the ones I had seen as being correct. Later I looked at other entries. The volunteer fixed it and sent a new file which worked correctly. Lesson learned- don't edit in Excel before entering into FM if formatting can be changed in Excel.