date based value list (limit)

[jorfasan]

When I setup via relationship a valuelist of a date field I logically obtain a (text) list of dates. But I need to use it to control a relationship with a date field and the stuff only works when text valuelist and date field are equally formatted. I use the european date format, sorry

V.list

6/1/2012

7/1/2012

8/1/2012

13/1/2012

can not be relationated to the date field

06/01/2012

or can not be found in the vList via PatternCount.

Well, it does work when the date is from october / nov / dec on 10th to 31th

But useless, of course.

The issue is solved with relationship multipredicate but I have to set up (it is a week control screen) 7 times the seven dates, instead a easy one.

Do I miss something basic or easier?

Thanks in advance.

[comment]

I don't quite follow your description. It sounds like you are entering a date into a Text field instead of into a Date field? I don't think the exact method of entry - typing or selecting from a value list - is the deciding factor here.

[jorfasan]

Hi Comment, thanks for answering.

Let me try a example and I will sent to the fmforums. As told before I could solve the issue but I will try to explain it in the DB.

In a couple of days. :-)

Thanks!

[jorfasan]

Just to thank your dedication to FMForums, Comment, I have to say that I have not been (¿fortunately?) able to reproduce the issue... again.

I opted for another schema and the problem disappeared just because I reuse the code / functions in the real file. Probably you were right and I was in the middle of a mistake. :-)

Thanks,