Topic: Convert to date gives null
Convert to date gives null
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
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
Which date masks are you using? Seems from your data you should be using a date mask like this:
dd/MM/yyyy HH:mmWhen I do that, those values seem to be parsed correctly.
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.
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.
Log in by clicking the login link at the top of the screen
Go back to forum.
