'Fuzzy' Dates

AaronS
AaronS Member Posts: 2
edited 2005-08-09 in NAV/Navision Classic Client
:cry:

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

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • Kowa
    Kowa Member Posts: 926
    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.
    Kai Kowalewski

Categories