topic Re: Date in incorrect format in Application Development and Automation Discussions

Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:22:49 GMT

Hi,

I have one program which creates variant.The variant date created by the program is wrong 1//20/05/2.

What would be the issue?

As per my knowledge, we get this error because we pass date to an internal table in MM/DD/YYYY format instead of YYYYMMDD. Usually programs take YYYYMMDD format and displays the output in MM/DD/YYYY. But i am not finding any such case here in the program to solve the issue.

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:39:45 GMT

Hi,

Check the date format in the internal table while creating the variant. The format would be MM/DD/YYYY and you are passing this value to another date field in which only first eight char will be moved.

So convert the MM/DD/YYYY to YYYYMMDD and move this to value in the variant.

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:40:45 GMT


*convert date yyyymmdd to mm/dd/yyyy

    concatenate itab-process_date+4(2)
                itab-process_date+6(2)
                itab-process_date(4)
           into it_fin-doc_dt separated by '/'.

hope this will help u

regards,

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:43:32 GMT

Hi,

Please check the type for the date fields. It should be DATUM.

This will help.

Regards,

Prashant

Re: Date in incorrect format

SujeetMishra — Thu, 04 Jun 2009 08:47:10 GMT

Hello Raju,

Please once have a look at FM below :

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL.

User This to convert your date format according to your need.

may this will solve your problem.

Regards,

Sujeet

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:52:56 GMT

Hi,

use FM RSEC_DATE_CONVERT to convert date into internal format.

Regards,

Raju.

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:57:57 GMT

Hi,

concatenate jtab-process_date+4(2)

jtab-process_date+6(2)

jtab-process_date(4)

into it_fin-doc_dt separated by '/'.

write 😕 it_fin_dt.

regards,

munibabu.K

Re: Date in incorrect format

Former Member — Thu, 04 Jun 2009 08:59:58 GMT

SYST_DATUM or SY_DATUM also no issue. am i correct?