Date Error

[Former Member]

Hi All,

I Am using a function module to fecth some data from a table

the issue is with the date format the value of date is blank inside the function module but when it is exported it gives me junk value as this '###ఠ 000'

my date personal date format is YYYY.MM.DD. Can anyone tell me why is this happeneing there is no manipulation happeneing in the date till it is exported

Regards,

Simin.R

[Former Member]

Hi Simin,

If you export the data to excel then please explore(just expand) the date colomn. If you do like this then you can get your correct date value. still if it is not work then need to check again.

Cheers,

Bujji

[Former Member]

hI,

Problem is with ur stru/itab where u geting data from FM. change particular filed type as c with with length 10 e.g. date(10) type c.

Or convert that field with FM like dateinternal

Jogdand M B

[Former Member]

Hi All,

Thanks for your reply. Am not exporting to an excel, Am exporting to an internal table and both the fields are of same domain "DATS". and my field is having a length of only 8 Char ie of data type DATS.

Regards

Simin.R

[Former Member]

declare the date field of length 10 and checkout if it works

[Former Member]

hi simin,

check whether the date field in whcih ur storing the date is having the length 10.

With Regards,

S.Barani

Message was edited by:

S BHARANIDARAN