Problems with date functions INC

[GoogleCodeExporter]

What steps will reproduce the problem?
1. import project with date in sql format [yyyy-MM-dd HH:mm:ss]
2. convert cells in column toDate [value.toDate('yyyy-MM-dd HH:mm:ss')]
3. Add column based upon this column and increment time 10 minutes 
[value.inc(10, 'minutes')]

What is the expected output? What do you see instead?
Whilst writing the transform the output appears to increment 10 minutes e.g 
from 2010-04-01T11:12:00Z to 2010-04-01T11:22:00Z, but when the transformation 
is applied both the original column and the new column increment 20 minutes so 
I have 2 columns saying 2010-04-01T11:32:00Z. If I go back a step in history to 
before the add column step the original column stays at this new time 
2010-04-01T11:32:00Z. I have to go back to before the toDate operation to get 
the original numbers back.

What version of Google Refine are you using?
Version 2.0 [r1836]

What operating system and browser are you using?
Windows XP SP3

Is this problem specific to the type of browser you're using or it happens in 
all the browsers you tried?
This happens in Firefox 4, IE 7, Chrome 11

Please provide any additional information below.
I attach the project with the problem. I also cannot get the diff function to 
work at all, it seems to struggle to recognise the dates in the columns

Original issue reported on code.google.com by a.br...@bury.gov.uk on 4 May 2011 at 8:38

Attachments:

• guestbookings.google-refine.tar.gz

[GoogleCodeExporter]

I believe this problem has been fixed in trunk/ by r1982:

http://code.google.com/p/google-refine/source/diff?spec=svn2052&r=1982&format=si
de&path=/trunk/main/src/com/google/refine/expr/functions/date/Inc.java&old_path=
/trunk/main/src/com/google/refine/expr/functions/date/Inc.java&old=1613

It'll be available in the next release.

Original comment by dfhu...@gmail.com on 4 May 2011 at 5:09

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by tfmorris on 9 Jun 2011 at 7:58

• Added labels: Milestone-2.1