I'm working with some data that I have imported from another system, and it has a very strange date format. It seems like everything after 1/1/2000 has the year formated with a letter. For example, 11/04/A0 or 08/04/B6. I have never seen this format before and I'm not sure how to translate this into a date that I can compare. Has anyone else seen it or know what it is?
Well, if I understand correctly, it solves the Y2K problem up to the year 2059. Where A = 200x, B = 201x, ..., F = 205x
7 2096
I have never heard of that. The first thing that jumps to mind is a hexadecimal decade system where A0 would be 2000 because 00 would be 1900. And B6 would be 2016.
I think that your link is exactly the date format that I have, but the patch that it talks about doesn't seem to be available anymore. Also, I don't believe that it is an Image SQL database.
I can't find anything about a hexadecimal decade system, so I'm not sure how to convert it to a year. Simple hexadecimal to decimal doesn't make sense either.
Well, if I understand correctly, it solves the Y2K problem up to the year 2059. Where A = 200x, B = 201x, ..., F = 205x
Well, it isn't hexadecimal. One of the dates is 10/27/M4, which is 10/27/2124. So instead, I use the character code to determine how much to add to the 1900 of 0. But since the years below 2000 just use numbers, I have to test the beginning character of the year to see how to format the date. So here is the formula that I ended up using - =DATE(
-
IF(CODE(RIGHT(A1, 2))<65
-
,1900+A1
-
,1900+10*(CODE(UPPER(RIGHT(A1,2)))-55)+RIGHT(A1,1))
-
, LEFT(A1, 2)
-
, MID(A1, 4, 2))
Note: my dates have two digit month and day value always.
That was my next guess if it wasn't hex. This is a weird solution to Y2K
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Simon Brooke |
last post by:
I'm investigating a bug a customer has reported in our database
abstraction layer, and it's making me very unhappy.
Brief summary:
I have a database abstraction layer which is intended to...
|
by: Ishbel Kargar |
last post by:
Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my
mail-merge letters are doing strange things with date formats. For
instance, my reminder letter for lapsed subs carries...
|
by: deiopajw |
last post by:
I have a problem with the date format of one particular date field.
I want it to use the english UK/australian date format ie 26/10/05 and not
the U.S. format of 10/26/05.
For some strange...
|
by: Tariq Ahmad |
last post by:
hi,
i am having big issues in deploying my asp.net web application
to our web server.
dates do not behave the same as on my development machine yet
the web.config files are the same and both...
|
by: Tan |
last post by:
Could anyone tell me how I can not use british date format using
<globalization culture="en-GB" uiCulture="en-GB"/> in the webconfig
with the line of code above i can not get the format is...
|
by: Lurc |
last post by:
Hi all,
One field of Access table is date/time type, and format is long time.
In VB.NET, as this table linked to a datagrid, a strange date 12-30-1899 is
shown instead of the time expected....
|
by: mewanalwis |
last post by:
Dear Friends,
I have a rather strange problem which invloves SQL server and ASP. The
problem is this.
I have an ASP application which use a SQL server. it saves date values
with MM/dd/yyyy...
|
by: andreas |
last post by:
When I copy a vb.net project using date formats from one PC with a windows
date format f.e. dd/mm/yyyy to another PC having a format yy/mm/dd then I
get errors.
How can I change for a while in the...
|
by: Terry Olsen |
last post by:
Given that variable dt = "3/31/2007", why does it produce the following
exception on some machines? It works fine on my PC, but others have sent me
this exception information because it threw up on...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |