cannot parse a string to a date

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.

Please sign in to leave a comment.