'Enter date in the format __.__.____' Error message

[Former Member]

Hello folks,

           I have created a custom search help for a character field in SE11. It also populate date field when we press f4.

Now when ever i try to overwrite or change the character field using f4 option i am getting an error message  'Enter date in the format __.__.____' .

Did anybody face the same type of error ? Could anybody help me with suggestions ?

Thanks in advance,

Shyam.

[Former Member]

Hello folks,

           I have created a custom search help for a character field in SE11. It also populate date field when we press f4.

Now when ever i try to overwrite or change the character field using f4 option i am getting an error message  'Enter date in the format __.__.____' .

Did anybody face the same type of error ? Could anybody help me with suggestions ?

Thanks in advance,

Shyam.

[former_member129652]

Hi,

  Try to change the date format in SU01.  Make sure the date format in SU01 and your custom character field are the same.

[Former Member]

Hi Michael,

              I have already changed the date format but still facing the error.

There are two fields one character and date field on selection screen. When ever i try to change Character field using f4, am facing this error.

Thanks,

Shyam

[Former Member]

hi Shyam,

To paste piece of your code. how you define the two fields.

regards,

Archer

[Former Member]

Hi Dengyong,

           I have declared in a normal way of defining Select-Option variables as,

Select-options : s_qual for zlims-zsampid,

                        s_date for zlimks-zlimsdate

Regards,

Santosh.

[anubhab]

Hello Shyam,

         I guess your s_date type and search help date type is not matching. If those are different, you will get this type of error. And also, to be more sure, you can always debug your program and check out what is causing this error as suggested by others already.

Regards,

Anubhab

[Former Member]

Can you debug the code and see what value is being populated in the date field when you over write or change the character field? Probably, a wrong value is being populated in the date field which you will know when you debug. You can then make the necessary corrections.

[Former Member]

Hi Shyam,

please check in SE11 that your parameters in search help have the right data elements.

Regards,

Klaus

[Former Member]

Hi,

Can you debug the code and see if your date format is INTERNAL or EXTERNAL

[Former Member]

Hi,

  After i debugged i found the below result.

Actual format is 23.09.2013 but when i debug SAP program taking it as 20.9..22.0

The data type i have given for the date field is DATS.

Do i need to change it. Please suggest.

Thanks in advance,

Shyam.

[Former Member]

Hi,

sap reads the date yyyymmdd only.

Regards,

Raman

[Former Member]

Hi Raman,

           Thats true. but i am sending value through search help. So SAP automatically should take it as yyyymmdd.

Thanks,

Shyam.

[Former Member]

Hi,

Your field zlimks-zlimsdate should have a data element like datum.

Use the function module CONVERT_DATE_TO_INTERNAL. your Actual format is 23.09.2013 to

yyyymmdd.

Thanks,

Rogelio

[Former Member]

Mostly the date entered might not be in the correct format. The error is corresponding to the date so please check if you are providing correct date format or not.

Regards,

Rafi