Birthdate_1

We're populating birthdates for our Hall of Fame members and have noticed that Birthdate_1 doesn't allow for dates in the 1800s - any way around this? A setting I'm not aware of? Have you run into this or have a fix? -Courtney cowen@countrymusichalloffame.org
  • Former Member
    Former Member $organization

    Hi Courtney

    The "dates" in the keyword table are actually stored in the table as the text equivalent, in iso format. (yyyy-mm-dd, which is SQL Server's native format, more or less). When you enter a date using the little date-picker, the date you select is presumably converted to that format, and then saved. It's probably that conversion that doesn't cope with 1800-y dates. 

    There is a bit of a work-around, I think, by changing the keyword definition,which would only work if you only need to enter a limited set of dates. That is, you wouldn't want to leave this setup in place - just switch it on, enter your early dates, then switch it off again. By the sound of it, that might be ok for what you need to do.

    If you

    • go into the t_Keyword entry for birthdate_1 
    • and change the "Edit Mask" setting from Date to AlphaNumeric
    • You can then manually enter your dates in the form '1852-07-25'.
    • And when you're done, change the Edit Mask value back to Date.

    That date will display correctly, although you won't be able to edit it without doing the switch again, of course. And it may not report correctly, although it probably will. It certainly works fine in List Manager.

    HTH 

    Ken