cannot parse a string to a date

2 followers
0
Avatar
datameer.dap.common.exception.ComputationException: starttime1: =ASDATE(#starttime;"MM/dd/yy HH:mm:ss") failed with IllegalArgumentException: Cannot parse "3/29/2015 2:04": Illegal instant due to time zone offset transition (Europe/Madrid)
Alicja Malota

1 comment

  • Avatar
    Konsta Danyliuk

    Hello Alicja.

    This error occurs because time stamp 3/29/2015 2:04 doesn't exist in the time zone Europe/Madrid. In 2015th Daylight Saving Time started in Spain on Sunday, 29 March 2015, at 02:00:00 clocks were turned forward 1 hour to Sunday, 29 March 2015, 03:00:00 local daylight time instead. Therefore 29 March 2015 02:04 has never happened.

    Please check our KB article How to Work with Datetime Values from Different Time Zones, it shows an example how to handle such cases.

    0
Please sign in to leave a comment.