I cannot reproduce this on My Windows Xp system. I created a second related table and entered dates into three related records. Both the date field in the related table and the field where I have formatted it with this value list are of type date. I specified "include only related values starting from" and specified the table occurrence of the layout shown here.
Make sure that the default language of the date field is not 'Unicode', mine was french but i know it happen with other language.
Both date fields where set to English.
Changing the language of the date field to French in the values table resulted in a single value (The smallest date) and a question mark displaying. This suggest that some language settings other than English may not index correctly.
Thank you for your posts.
Thanks to the files sent in by DavidWikstrom, along with your posts, I am able to replicate the problem.
This is a bit more complex, as one of the files DavidWikstrom sent in was marked as "Canada". The Date field language settings were set to French, and when changed to English, the Value List still displayed "?". However, thanks to your discovery, changing the Date field language setting to Unicode allows the Value List to display properly.
I have sent along your posts along with my findings to our Development and Testing departments so they can hopefully provide some additional information. I will keep you posted as information becomes available to me.
Hi David, sorry i made a new thread about this issue, found yours after i made mine, had some trouble accessing the forum to report the issue so when i was able to do so I did without rechecking if there was already a thread.
And by the way TSGal, changing the field language setting wasn't my discovery, it was suggested by a fellow developper after I sent an example of the bug.
Salut Maxime ;-)
Well, I just posted my report after I heard of the bug from you on the FMQC mailing list... So we can all share the glory! Better to post once too many when there's are real bug! Especially one like this, that can be pretty fatal to any Canadian user of FileMaker 12.