I have a client that has FM Pro 12 DB and when porting (Copy and pasted) their layout into
their new FM Pro Adv 16 the Date fields all show as ?.
I verified that they are not stacked fields.
How can I fix this for them?
To fix this issue I ,
1) Exported the old SOURCE data as a FM file and as a XLSX file.
2) Imported the FM data into the new built system, then imported the XLSX data.
Now all old and new dates work with no more ??? in their places.
Oh and when you click in the field the original data does show up. When you leave the field it goes back to ?
Make the field wider and all should be good. A ? can mean that the field is too narrow to display its contents correctly.
I moved it to an open area on the layout and made it 2x as long and 2x as high and still only get ?
Try creating a brand new field object using the field tool or the field picker and see if you get the same results.
That works! just like it should, what is wrong with the ones copied and pasted?
Can't tell from here.
Check the style and data format settings.
Check to be sure that the field's type is date and not text or number.
Thank you again Phil! You rock as usual!
Here is a new one for you Phil, You drag out a field from Field Picker (Date Field) and upon running
you get > ?
Now I drag out the same field again leaving the other one still on the layout and upon running
you get > May 1, 2018
Now how darn odd is that?
I wonder if your layout is corrupted.
Try a brand new layout with nothing pasted into it.
Might try recovering the file just to check for issues.
Hey Phil, the ?'s are back in the date fields.
If I go to a new Layout and drop 2 of the 14 date fields on the layout the same thing happens I get ? instead of the
date data showing up. If I click in the field the data shows, but when i leave the field it goes back to ?.
Also the prev ver was FM Pro 15 and moved to FM Pro adv 16
Thoughts on why and what is making this happen?
Also note that if you click in the field and see the date and use the picker to pick the (past date again) they date
stays showing up and no ? shows but if I go to another previous rec with the date in the field it shows as ?
unless I repeat the above action.
This is only affecting Older records not new records.
Is the date field long enough to display the format you selected?
Since you’ve already tried resizing the field, try this:
save a clone of your file.
Export the data from this table into a merge file. Then import the merge file into the clone and see if this fixes the ? Issue.
Yes more than large enough to fit
Also I noticed that if I do a find like this <2/15/2018 I should get like 3000 + records
But I get the following:
If I do a find like this ? It gives me several thousand records.
this did not fix the issue.
Retrieving data ...