search

ghmo / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

datePart(value,"month") gives zero-based month numbers #115

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.on a column od date edit cells ... transform
2.datePart(value,"month")
3.

What is the expected output? What do you see instead?
I would expect Jan to be 1 and dec to be 12. I get 0 and 11.

What version of the product are you using? On what operating system?

Please provide any additional information below.

Original issue reported on code.google.com by Da...@appliedminds.com on 16 Aug 2010 at 7:01

GoogleCodeExporter commented 8 years ago 
Ah, good catch Danny. This is a side effect of Java's date parser that actually 
uses zero-based month numbers, but I agree that's unfortunate. I'll fix that.

Original comment by stefa...@google.com on 16 Aug 2010 at 3:59

GoogleCodeExporter commented 8 years ago

Original comment by stefa...@google.com on 16 Aug 2010 at 3:59

GoogleCodeExporter commented 8 years ago 
Fixed in r1161.

Original comment by stefa...@google.com on 16 Aug 2010 at 4:10

GoogleCodeExporter commented 8 years ago

Original comment by tfmorris on 18 Sep 2012 at 2:58