datacleaner (#1) - Convert to date gives null (#280) - Message List
Hello all, I am facing a problem with COnvert to date transformer. It detects null values when it shouldn't. It only happens when hour is 3:XX. Example rows, string and conversion result:
28/3/2009 12:50 Sat Mar 28 12:50:00 EET 2009 29/3/2009 2:55 Sun Mar 29 02:55:00 EET 2009 28/3/2009 12:55 Sat Mar 28 12:55:00 EET 2009 29/3/2009 3:05 <null> 28/3/2009 13:00 Sat Mar 28 13:00:00 EET 2009 29/3/2009 3:15 <null> 28/3/2009 13:05 Sat Mar 28 13:05:00 EET 2009
-
Message #958
Which date masks are you using? Seems from your data you should be using a date mask like this:
dd/MM/yyyy HH:mm
When I do that, those values seem to be parsed correctly.
kasper01/26/12 15:42:22 (4 months ago) -
Message #972
Thanks for your reply and for attempting to replicate the problem.
This is indeed the used mask. I tend to believe it is a PC specific issue since it works normally on other PCs. It is strange, however, since there is no possible codepage or similar misconfiguration that could cause this.
satjat01/30/12 10:59:59 (4 months ago)
