topic Re: check a date validity in Application Development and Automation Discussions

check a date validity

former_member246786 — Thu, 16 Apr 2009 15:02:47 GMT

Hi there,

I would like to know how to check the validity of a date ?

By validity I does not mean "format" but the existence of the date in daily calendar (no need to check in enterprises calendars).

For example 12

Do you have any idea ?

thanks a lot

Regards

Morgan

Re: check a date validity

former_member156446 — Thu, 16 Apr 2009 15:09:39 GMT

PARAMETER: p_date TYPE sy-datum.

its being checked if its declared as sy-datum.

Re: check a date validity

SuhaSaha — Thu, 16 Apr 2009 15:16:27 GMT

Hello Morgan,

I will like to add to J@y's post if you declare the date as TYPE datum compiler automatically performs the check for you.

Hope i am clear.

BR,

Suhas

Re: check a date validity

former_member246786 — Thu, 16 Apr 2009 15:19:32 GMT

Hi,

thanks but I never tell that the dat was a parameter ... it's just a variable filled in from a file.

If I try to fill on a variable of type datum, it works but the date is not consistant ...

Re: check a date validity

Former Member — Thu, 16 Apr 2009 15:24:49 GMT

REPORT ZTEST MESSAGE-ID Z1.

data: lv_date type sy-datum,

lv_msg(50) type c.

lv_date = '20051232'.

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'

EXPORTING

DATE = lv_date

EXCEPTIONS

PLAUSIBILITY_CHECK_FAILED = 1

OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4 into lv_msg.

write: lv_msg.

ENDIF.

Re: check a date validity

former_member156446 — Thu, 16 Apr 2009 15:26:20 GMT

Check this conversation on a similar issue :

Re: check a date validity

Former Member — Thu, 16 Apr 2009 15:28:52 GMT

Try FM DATE_CHECK_PLAUSIBILITY

Rob

Re: check a date validity

Former Member — Thu, 16 Apr 2009 15:37:18 GMT

DATE_CHECK_PLAUSIBILITY :Check for the invalid date.

This function module checks if the date is in valid format for sap.

It also check if it is valid calender date or no.

So this should work for your requirement.

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'
     EXPORTING
          DATE                                         = p_date
     EXCEPTIONS
          PLAUSIBILITY_CHECK_FAILED   = 1
          OTHERS                                    = 2.
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

If the value of Sy-subrc is 0 that means the date field has a valid value.

If the input is 01/01/2008 then the output of the above program is as follows.

Validate the date 0

If the input is 31/31/2008 then the output is as follows.

Validate the date 1

Regards,

Lalit Mohan Gupta.