topic Re: Date Error in Application Development and Automation Discussions

Date Error

Former Member — Wed, 23 May 2007 06:19:25 GMT

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

Re: Date Error

Former Member — Wed, 23 May 2007 06:23:08 GMT

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

Re: Date Error

Former Member — Wed, 23 May 2007 06:23:59 GMT

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

Re: Date Error

Former Member — Wed, 23 May 2007 06:26:52 GMT

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

Re: Date Error

Former Member — Wed, 23 May 2007 06:28:00 GMT

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

Re: Date Error

Former Member — Wed, 23 May 2007 06:29:14 GMT

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