Calculation of date past 12/31/2031

Discuss plans for a future version of HanDBase for the Google Android platform

Calculation of date past 12/31/2031

Postby jonlyng » Wed Apr 25, 2018 4:56 pm

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
Posts: 1
Joined: Fri Sep 16, 2016 2:14 pm

Re: Calculation of date past 12/31/2031

Postby ddhsoftwareadmin » Sat Apr 28, 2018 10:16 pm

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.
Site Admin
Posts: 429
Joined: Tue Dec 09, 2008 2:13 pm

Return to HanDBase for Android

Who is online

Users browsing this forum: No registered users and 2 guests