'Fuzzy' Dates

AaronS

Working on a clients db. They want a 'fuzzy' birthday for people. A month/day but no year. They want it stored in the 'Date of Birth' field. I was thinking of another field called fuzzy birth day but was wondering if there might be a work around.

Any suggestions
Aaron

kriki

The only thing I can come up with : use 2 integer-fields for it. In the integer-fields you might also set the minimum and maximum value.

Marije_Brummel

You can make a date field and set the format property to

[/code]<Day>-<Month>

This way, they can enter the real date of birth but only day and month er visible.

Kowa

If you want to filter and sort the customers to find the persons who have their birthday in the current month or to print a birthday list you will have to use separate option fields for "Day" and "Month". You can use the DATE2DMY function to fill these fields automatically after the birthday has been entered into a "Date" field.