topic Re: Validate date in yyyymmdd format in Application Development and Automation Discussions

Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:21:46 GMT

Hi All,

I am looping an internal table which has a date field and if date(comes from input file) is not in YYYYMMDD format, it should throw an error message.

Can anybody please tell me how to validate date for YYYYMMDD format

Is there any specific function module for that?

Regards,

Azra.

Re: Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:26:08 GMT

Hi,

Check this FM DATE_CHECK_PLAUSIBILITY

Refer to this link..

Re: Validate date in yyyymmdd format

former_member195383 — Thu, 07 May 2009 06:27:08 GMT

change your SU3 settings to the desired date format, and then use FM

DATE_CHECK_PLAUSIBILITY

Check the below link for more info.

Re: Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:27:21 GMT

Hi,

If for the internal table you have declared the field as sy-datum, then it will take the date in sy-datum format only.

But later to validate u cna loop in that internal table and pass the date value to the FM '/OSP/VALIDATE_DATE_TIME' to check whether its the required format.

Regards,

Mansi.

Re: Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:30:12 GMT

Hope this function module will help you

FM : " /OSP/VALIDATE_DATE_TIME "

Re: Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:33:09 GMT

hi,

use:

/OSP/VALIDATE_DATE_TIME

DATE_CHECK_PLAUSIBILITY

Re: Validate date in yyyymmdd format

Former Member — Thu, 07 May 2009 06:43:40 GMT

Hi,

First declare the field as type d.

In the loop you check the data wiht offset values: v_datae+0(4) = 'YYYY',

v_date_4(2) = 'MM', v_date+6(2) = 'DD'.

If not then throw an error message.

Naveen M.