Hi Dominik,
Dominik Fretz [mailto:[EMAIL PROTECTED]] wrote: > > I have to import datas from a textfile (CSV). Some fileds > which have to > bee importet are Date fields (the destination DB-fields are > of the type > Date) and are in the format 'dd.mm.yy'. > Everything works fine until the date '29.02.00' (2000 was a > leap year!) > have to be imported, then repcli gets a error: > > Invalid input for date or time column: 29.02.00 > > How can i tell SAPDB 2000 was a leap year and this date is valid? > > FYI: The Server is version: 7.3.0.29 > I'm pretty sure that's not a problem of recognizing the leap year but rather a format problem. Did you specify the special format in the command for the date? For the RepMan the format you used is special (the default is INTERNAL := YYYYMMDD) and must be specified like this DATALOAD table <table name> <col specs> ... INFILE <file name> DATE 'DD.MM.YY' Regards, Steffen _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
