Page 1 of 1

Calculation of date past 12/31/2031

PostPosted: Wed Apr 25, 2018 4:56 pm
by jonlyng
Is there a way to enter or calculate a date past 12/31/2031? This seems to be the largest date you can select. Also the program does not seem able to calculate dates beyond the 12/31/2031.

As an example, I have a date field with the date of 12/22/17. If I add 14 years and 12 days to the date it calculates to 12/31/2031 which is fine. However, if I add 14 years and 13 days it calculates to NO DATE and 14 years and 14 days calculates to 1/2/1904.

Is there a fix for this?

I am using HandBase Professional 4.6.2 Build R2 on an LG G4

Thank you in advance for any help

Re: Calculation of date past 12/31/2031

PostPosted: Sat Apr 28, 2018 10:16 pm
by ddhsoftwareadmin
Hi there,

Thanks for writing. Indeed 12/31/2031 is the highest date in the date range supported in a date field in HanDBase at this time. If you need to go higher you would have to use a text field and just enter the date manually. I have also seen users create 3 fields with drop downs (month, day, and Year) as an alternate to the HanDBase date field. They were needing dates going back to before the oldest date supported in HanDBase- your request is the first to want to go beyond 2031, but I'm sure as the years go on, there will be more. And it will require a format change to a 64 bit value to support a larger date range so will only align with a major update to HanDBase.