Date characteristics wrong

[Former Member]

Hello All

When i execute the report in BEx, i get a error pop up sayin that the "Value '16.09.20' of 0DATE Characteristics is not a number with 000008 spaces.

Error Reading Info Provider , Error while reading the data.

The report is based on a consolidate dso, which is getting fed by 2 dso's. I tried checking the date fields of all the date characterisitcs present in the dso, but i dont find this Date.

Can any 1 advice me, how to find this date value??

thanks

[Former Member]

DEC Type was defined for the date field, so changed it to DATS

[Former Member]

You can go to "Manage", Active Data, and try to search for invalid dates by specifying "Exclude Ranges", for example, excluding the range 1/1/1900 to 1/1/2099.

[Former Member]

Hi,

Are you using a customer exit variable to do some calculation based on date char...just check if its written properly or not.

Thanks

Ajeet

[Former Member]

Hi Ajeet, Kurt

Thanks fr the replies.

The date data gets loaded correctly in PSA.This release date field has been enhanced in the dscrc and hence forth i used the info object 0APO_RELDAT.

In PSA the date shows 19.02.2008, but when it comes to DSO, the same date shows something like this 20.2..19.0

I checked the general properties of the 0APO_RELDAT. The lenght is 8, output lenght is 10, Conv routine is BLANK and there is no transfer routine exists.

So y is this problem occuring, I tried writing a Date conversion formula as DATECONV(APO RELDAT, YYYYDDMM, ' ' ) but this is nt acceptiong.

Can any 1 help me ASAP

thanks

[Former Member]

Convert to YYYYMMDD format, for example, 20080219.