Solved

Looking for example pivot year code used in Y2K

Posted on 2016-10-19
4
46 Views
Last Modified: 2016-10-23
I need to explain Y2K pivot year code and I am looking for an example.
0
Comment
Question by:Alex972
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
I think that what you are talking about is what logic does Access use to determine the century when you enter only two digits of year.  The pivot is 29.  So 00-29 default to the 21st century and 30-99 default to the twentieth.

1/1/29 is assumed to be 1/1/2019
1/1/30 is assumed to be 1/1/1930
1
 
LVL 27

Expert Comment

by:Glenn Ray
Comment Utility
^Yes, also true for Excel.  Up to 12/31/29, the internal date is stored as year 2029 (47483).  On 1/1/30, it is stored as year 1930 (10959).

No points for me; just adding to @PatHartman 's post.
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
I would also add that years should be displayed as four digits, especially in apps where you will commonly have 20th century and 21st century dates.  If for space reasons you need to limit to 2-digit years, I would suggest a conditional formatting rule that makes the date red if it is 20th century.
1
 

Author Closing Comment

by:Alex972
Comment Utility
Thanks
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

A short article about a problem I had getting the GPS LocationListener working.
A short article about problems I had with the new location API and permissions in Marshmallow
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now