November 20, 200124 yr 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?
November 20, 200124 yr 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)
November 20, 200124 yr Create a calculation text field... code: MonthName (date) & " " & Year (date) ...and search on it using the format "November 1989"
November 21, 200124 yr Author 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.
Create an account or sign in to comment