D3 and mvBase

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:

SET-DATE-WINDOW 60

This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.

I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp

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

Thanks for this Brian - useful to know

------------------------------
Stefano Gallotta
Managing Member
Simply Red Open Systems
Milnerton ZA
------------------------------

Original Message:
Sent: 08-16-2022 17:26
From: Brian Cram
Subject: set-date-window to mitigate effects of 2-digit year

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:

SET-DATE-WINDOW 60

This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.

I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp

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

I might need a new Manual!!

I use set-date-eur, will set-date-window 60 work with the International Date format?

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au <apolglaze@book-keepingnetwork.com.au>
https://www.book-keepingnetwork.com.au <https: www.book-keepingnetwork.com.au="">























Original Message:
Sent: 8/16/2022 5:26:00 PM
From: Brian Cram
Subject: set-date-window to mitigate effects of 2-digit year

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:

SET-DATE-WINDOW 60

This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.

I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------
</https:></apolglaze@book-keepingnetwork.com.au>

Hi Alex Polglaze

That's equally a good question.

P.S. If you get (a new manual) please distribute it to the rest of us :) I still refer to Jonathan Sisk's Pick Pocket guide of 1982!

Joking - this link helps:

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/92/refman/

------------------------------
Stefano Gallotta
Managing Member
Simply Red Open Systems
Milnerton ZA
------------------------------

Original Message:
Sent: 08-17-2022 09:28
From: Alex Polglaze
Subject: set-date-window to mitigate effects of 2-digit year

I might need a new Manual!!

I use set-date-eur, will set-date-window 60 work with the International Date format?

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au

Mine is Advanced Pick, Fourth Edition (Version 2.0) January 1995

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au <apolglaze@book-keepingnetwork.com.au>
https://www.book-keepingnetwork.com.au <https: www.book-keepingnetwork.com.au="">























Original Message:
Sent: 8/17/2022 9:49:00 AM
From: Stefano Gallotta
Subject: RE: set-date-window to mitigate effects of 2-digit year

Hi Alex Polglaze

That's equally a good question.

P.S. If you get (a new manual) please distribute it to the rest of us :) I still refer to Jonathan Sisk's Pick Pocket guide of 1982!

Joking - this link helps:

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/92/refman/

------------------------------
Stefano Gallotta
Managing Member
Simply Red Open Systems
Milnerton ZA
------------------------------

Original Message:
Sent: 08-17-2022 09:28
From: Alex Polglaze
Subject: set-date-window to mitigate effects of 2-digit year

I might need a new Manual!!

I use set-date-eur, will set-date-window 60 work with the International Date format?

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au</https:></apolglaze@book-keepingnetwork.com.au>

Yes:

eurWin
001 execute \set-date-eur\
002 execute \set-date-window 30\
003 print oconv(iconv("8/9/31","d"),"d")
004 execute \set-date-window 60\
005 print oconv(iconv("8/9/31","d"),"d")

:run bp eurWin

Current Date Window: 30

08 Sep 1931

Current Date Window: 60

08 Sep 2031

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

Original Message:
Sent: 08-17-2022 09:28
From: Alex Polglaze
Subject: set-date-window to mitigate effects of 2-digit year

I might need a new Manual!!

I use set-date-eur, will set-date-window 60 work with the International Date format?

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au

And you guys apparently need a new browser as well as a new manual (LOL):

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

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

Original Message:
Sent: 08-17-2022 10:20
From: Brian Cram
Subject: set-date-window to mitigate effects of 2-digit year

Yes:

eurWin
001 execute \set-date-eur\
002 execute \set-date-window 30\
003 print oconv(iconv("8/9/31","d"),"d")
004 execute \set-date-window 60\
005 print oconv(iconv("8/9/31","d"),"d")

:run bp eurWin

Current Date Window: 30

08 Sep 1931

Current Date Window: 60

08 Sep 2031

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

Original Message:
Sent: 08-17-2022 09:28
From: Alex Polglaze
Subject: set-date-window to mitigate effects of 2-digit year

I might need a new Manual!!

I use set-date-eur, will set-date-window 60 work with the International Date format?

Alex
--
Alex Polglaze
The Book-Keeping Network
(08) 9349 9189
+61 419 776 348
apolglaze@book-keepingnetwork.com.au

Hey Brian,
This one is definitely good to know.

Thanks,
Vincent

------------------------------
E Bearings2017
ITC Coordinator
Bearings & Accessories Ltd
General Post Office JM
------------------------------

Original Message:
Sent: 08-16-2022 17:26
From: Brian Cram
Subject: set-date-window to mitigate effects of 2-digit year

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:

SET-DATE-WINDOW 60

This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.

I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp

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

Did anybody realise that yesterday, 3rd October 2022, was Day 20,000 in the Pick/D3 calendar? It brought back memories of Y2K and our Day 10,000 challenge. Hang on, it wasn't a challenge at all, just right justify the date field to accommodate the extra digit. Ah, the elegance and simplicity of good design.

------------------------------
Alex Polglaze

The Book-Keeping Network
Perth Western Australia
+61419 776 348
apolglaze@book-keepingnetwork.com.au
https://www.book-keepingnetwork.com.au/
------------------------------

Original Message:
Sent: 08-16-2022 17:26
From: Brian Cram
Subject: set-date-window to mitigate effects of 2-digit year

Everyone out there know about D3's SET-DATE-WINDOW utility? It's something you can add to your cold start procedure to change the 2-digit year pivot point from 30 to something else. Example if you ICONV a date like 8/1/31, you'll get an internal date in the year 1931, not 2031 as you might expect. I have this in my USER-COLDSTART:

SET-DATE-WINDOW 60

This tells my D3 system to assume that any two-digit years from 00 to 59 are 2000 to 2059, where 60 to 99 are 1960 to 1999. This is a LOT handier than handling it in your application.

I'm posting this because there's a lot of useful stuff in D3 that I was unaware of until I became a Rocket employee and was actually forced to read the manual. Maybe some of you are in the same boat.

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/103/refman/index.htm

https://www3.rocketsoftware.com/rocketd3/support/documentation/d3server.jsp

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