User avatar
Jared
Forum Admin
Posts: 3917
Joined: Mon Jan 12, 2015 12:32 pm
Location: Providence, RI
Contact: Website Facebook Twitter Skype YouTube Google+

Seagate Date Code Conversion Translation Tool

Mon Oct 12, 2015 3:34 pm

Here's a little excel tool I built to convert Seagate date codes into actual dates:



Hope it helps someone who's having difficulty understanding how the code works.

The basic formula is:

First Two Digits = Year (E.G. 08 = 2008 However it's the fiscal year starting the first Saturday in July of the previous year, strange I know)
Next Two Digits = Week of year (numbered 1-52)
Last Digit = Day of Week (numbered 1-7)

The calculator basically splits up the digits, then starting from the first Saturday in July of the year adds 7 days for each week and one day for each day of the week in the code. Then it subtracts 8 days since the code really starts on week 1 day 1, not week 0 day 0.

User avatar
pclab
Forum Moderator
Posts: 1801
Joined: Tue Jan 13, 2015 4:55 pm
Contact: Website Facebook

Re: Seagate Date Code Conversion Translation Tool

Mon Oct 12, 2015 5:56 pm

Nice work hehehe
www.pclab.com.pt
facebook.com/PCLAB.Assistencia.Tecnica

User avatar
LarrySabo
Data Recovery Master
Posts: 907
Joined: Mon Jan 12, 2015 8:15 pm
Location: Ottawa, Canada
Contact: Website

Re: Seagate Date Code Conversion Translation Tool

Mon Oct 12, 2015 8:19 pm

I've been using this one, but they are only different by 3 days.

User avatar
Jared
Forum Admin
Posts: 3917
Joined: Mon Jan 12, 2015 12:32 pm
Location: Providence, RI
Contact: Website Facebook Twitter Skype YouTube Google+

Re: Seagate Date Code Conversion Translation Tool

Thu Oct 22, 2015 3:17 pm

If you want one that is an exact date there's actually a program on hddguru files section that is completely accurate: http://files.hddguru.com/download/Datas ... alculator/

User avatar
LarrySabo
Data Recovery Master
Posts: 907
Joined: Mon Jan 12, 2015 8:15 pm
Location: Ottawa, Canada
Contact: Website

Re: Seagate Date Code Conversion Translation Tool

Thu Oct 22, 2015 4:47 pm

That's the one I've been using, which I got from a colleague. I didn't realize he got it from HDDGuru (thanks to eignstein9).

User avatar
MiRa
Data Recovery Noob
Posts: 1
Joined: Thu Dec 01, 2016 3:08 am

Seagate Date Code Conversion Translation Tool

Thu Dec 01, 2016 3:32 am

Jared:

Thanks for the Date Code conversion calculator. It helped me out so I would like to return the favor.

In your note you said you couldn't find a mathematical way to determine the first Saturday of July, so I came up with one for you (see below). Basically it starts with the 1st of July and then adds as many days as necessary to move it to the first Saturday. If July 1 is a Saturday, it adds 0 days.

===============================================
July1st = July 1, YY-1
1stSatInJuly = July1st + Mod(7 - Mod(July1st, 7), 7)
===============================================

In Excel:
Mod(7 - Mod(July1st, 7), 7)

Will return:
0, 6, 5, 4, 3, 2, 1 for Sat, Sun, Mon, Tue, Wed, Thu, Fri respectively

User avatar
Jared
Forum Admin
Posts: 3917
Joined: Mon Jan 12, 2015 12:32 pm
Location: Providence, RI
Contact: Website Facebook Twitter Skype YouTube Google+

Seagate Date Code Conversion Translation Tool

Thu Dec 01, 2016 4:03 pm

Thanks for that.

The formula actually had to be typed as:

=Mod((7 - Mod(E7, 7)), 7)


Where E7 was a cell which concatenated "7/1/" with the year from the date code.

I always figured it was possible to do, I was just too lazy to figure out the math. Didn't think to use the Mod function for a date.

User avatar
Jared
Forum Admin
Posts: 3917
Joined: Mon Jan 12, 2015 12:32 pm
Location: Providence, RI
Contact: Website Facebook Twitter Skype YouTube Google+

Seagate Date Code Conversion Translation Tool

Thu Dec 01, 2016 4:14 pm

Now, my tool is actually better than the one on HDDGuru because I actually built in a logic function to determine the correct century.

Just in case anyone has a 1999 drive using this date code system. :lol:

User avatar
Amarbir[CDR-Labs]
Data Recovery Pro
Posts: 512
Joined: Sat Jan 17, 2015 4:35 pm
Location: Chandigarh ,India
Contact: Website Skype

Seagate Date Code Conversion Translation Tool

Sat Dec 03, 2016 11:57 am

Thanks Jared ,
Very Helpful
Regards
Amarbir S Dhillon ,CDR Labs [ Chandigarh ,India ]
DataRecovery - The Affordable Way In India
Youtube Channel -> https://www.youtube.com/channel/UCbIeLFJWxTux8TQu_QSCsgQ?view_as=subscriber

Return to “Seagate Data Recovery”

Who is online

Users browsing this forum: No registered users and 0 guests