Skip to main content

Recent date issue

  • January 10, 2023
  • 3 replies
  • 0 views

Ben Cramer
We ran into this recently and I thought I'd share.
In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033). 
After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.


------------------------------
Ben Cramer
Owner
Dealer Solutions LLC
Mansfield TX US
------------------------------

3 replies

Brian Cram
Forum|alt.badge.img+3
  • Rocketeer
  • January 10, 2023
We ran into this recently and I thought I'd share.
In the legacy/character version of our software, we normally prompt for dates using a two digit year (mm-dd-yy), iconving and oconving as needed.  Recently, a user entered "12-31-33" as a date.  The iconv returned -12418 (12-31-1933) rather than the expected value of 24107 (12-31-2033). 
After researching this we discovered that Pick/Rocket and QM both default to dates entered with 2 digit years greater than 30 to be in the 1900's, years less than 30 as assumed to be in the 2000's  Note: iconving a date with a 4 digit year always returns the correct value..  QM does have a config setting that will allow you to override the cutoff, however rather than remembering to change the config setting every few years on every user system, we opted to add code to our legacy system that checks the iconv'ed value and adjusts it as needed.


------------------------------
Ben Cramer
Owner
Dealer Solutions LLC
Mansfield TX US
------------------------------
Hi, Ben. D3 and mvBase both have SET-DATE-WINDOW to change the pivot point from 30 to whatever. I have SET-DATE-WINDOW 60 in my USER-COLDSTART. Please give that a try.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------

Ben Cramer
  • Author
  • New Participant
  • January 10, 2023
Hi, Ben. D3 and mvBase both have SET-DATE-WINDOW to change the pivot point from 30 to whatever. I have SET-DATE-WINDOW 60 in my USER-COLDSTART. Please give that a try.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
Thanks Brian!  I'll share with the team.

------------------------------
Ben Cramer
Dealer Solutions LLC
Mansfield TX US
------------------------------

Brian Cram
Forum|alt.badge.img+3
  • Rocketeer
  • January 10, 2023
Thanks Brian!  I'll share with the team.

------------------------------
Ben Cramer
Dealer Solutions LLC
Mansfield TX US
------------------------------
BTW, that came in mvBase v3.1 , not sure when it hit D3.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------