April 3, 2012 - Excel Date Time Code

Hi All,

If anyone else had their heart set on posting a question today, I'll save this one for a rainy day.

Here's a relatively quick one with a few minor pitfalls along the way.

Using Native Grasshopper components convert a Date and Time String into an MS Excel Date Time Code. It must be exactly what excel would produce.

For those of you who don't know: Excel uses a serial number to handle date and time it is worked out by the number of days from 1-Jan-1900.

Would welcome any Scripts as a secondary exercise or if there is a Plug-in out there with a component just for this let us know.

This was going to be incorporated into another question but I thought I would break it down into easily manageable bites

...............

SOLUTION MK2 (Leap year adjustment):

....................................................

WINNER: (one horse race) Systemiq

Attachments:

ghoffee_20120403_DateTimeCode_Native_Solution_mk2.gh, 39 KB

Replies to This Discussion

Permalink Reply by Michael Pryor on April 3, 2012 at 2:01pm

I am interested in seeing this one, good topic, strings are one area of GH I have 0% experience in.

Permalink Reply by Yoann Mescam (Systemiq) on April 3, 2012 at 6:58pm

Not checked against Excel and dates before 1900 will be wrong.

Permalink Reply by Danny Boyes on April 4, 2012 at 3:50am

Hi Systemiq,

Good effort, but I'm afraid your handling of different days in the month and leap years hold up to scrutiny. These were the pitfalls I mentioned :)

The dates 31-May-2011 and 01-Jun-2011 are the same in your method. Where as they should be 40694 and 40695 in the Excel Date Time Code serial number system

Permalink Reply by Danny Boyes on April 4, 2012 at 4:16am

Edit: Sorry that should have said does not hold up to scrutiny

Permalink Reply by Yoann Mescam (Systemiq) on April 4, 2012 at 6:51am

I will stay in the pit and let someone else correct my mistakes so !

I feel lazy =)

Permalink Reply by Danny Boyes on April 4, 2012 at 7:52am

Solution Posted Above

@Systemiq have a look at the Find Similar method instead of the Member Index. I noticed when checking yours that I accidently typed July instead of Jul. Find similar can cope with this however Member Index will not find a match.

Permalink Reply by Yoann Mescam (Systemiq) on April 4, 2012 at 9:25am

Good point.

Btw, is divisible by 4 enough to know if it is a leap year ?

Shouldn't also consider modulo 100 and modulo 400 ?

Permalink Reply by Danny Boyes on April 4, 2012 at 10:14am

Fixed

Permalink Reply by Michael Pryor on April 5, 2012 at 5:10pm

so..... will you do the next coffee topic?

RSS