2 Replies Latest reply on Sep 30, 2012 5:16 PM by Alex Kerin

    Problem with Date and time

    Amarendu Samal

      Hi,

       

      I have a set of data , where the date is in the following format.

       

      0609xxxx,10312xxxx,F,39,05/10/1994,CYxxxxxxxx xxxx

      0609xxxx,10312xxxx,F,39,05/10/1994,INxxxxx

      1094xxxx,10309xxxx,M,34,05/18/1994,Axxxx

      1094xxxx,10309xxxx,M,34,05/18/1994,Fxxx , xxxx

      1176xxxx,10311xxxx,M,40,05/10/1994,Lxxx

      1176xxxx,10311xxxx,M,40,05/10/1994,Uxxxxx

       

      when selecting the date column from the data set , its  shows an error message as

      Database error 0x80040E07:ERROR:date/time field value out of range:"05/18/1994";

      Error while executing the query

       

      what should i do to overcome this error message.

       

       

      Thanks in advanceerror.jpg