Wildcard in date field?

[Lange]

Does anybody know if it in any way is possible to define a wild card date, example: **.Nov.1980 for a record from November 1980 with unknown day?

[Thom]

If you're searching for a date, then use the range operator:

1/11/1980...31/11/1980

You may need a complex calc to determine which months have 28, 29, 30, or 31 days. Another approach is to make two Find requests. The first finds records from the first of the month to the first of the next month. The second request omits the first of the next month:

1/11/1980...1/12/1980

1/12/1980 (omit)

[Vaughan]

Create a calculation text field...

code:

---

MonthName (date) & " " & Year (date)

---

...and search on it using the format "November 1989"

[Lange]

Yup, the idea of creating a copy as a text field is my solution at the moment. Here I use wildcards like this: If I know my record is from November 1980 but I do not know the exact date I file it as: **.11.1980 (we use the DD.MM.YYYY - format in Denmark).

I would have liked to keep my field as a date-formatted field _with_ wildcards, but it seems to be impossible. Thanx anyway.