topic Re: Date Field Validation in Application Development and Automation Discussions

Date Field Validation

Former Member — Tue, 25 Nov 2008 02:39:13 GMT

HI Experts,

please help me how to validate the date field.

<<Text removed by moderator>>

Regards,

Sunita

Edited by: Matt on Nov 25, 2008 8:31 AM

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 02:53:40 GMT

check FM DATE_CHECK_PLAUSIBILTY

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 03:11:11 GMT

Hi,

Use select stmt


 AT SELECTION-SCREEN ON s_date.

SELECT SINGLE * 
         FROM table_name
         WHERE data_field  IN s_date.

  IF sy-subrc <> 0.
  message 'Error Message.' type 'E'.    
endif.

Thanks,

Krishna...

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 03:14:34 GMT

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'

EXPORTING

date = l_select_date

EXCEPTIONS

plausibility_check_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

date invalid

ENDIF.

Regards

Neha

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 03:15:17 GMT

i tried this but its not working

any more inputs.

regards

sunita

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 04:52:42 GMT

HI,

Try this.

tables : bkpf.

Select-options : v_budat for bkpf-budat.(this is u r selection-screen field.)

select single * from bkpf where budat in v_budat.

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 04:54:38 GMT

HI,

For date field validation you need not to do much

Just declare date field as type sy-datum and every validation will be managed internaly.

Syntax:

data:
   v_date type sy-datum.

parameters:
         v_date type sy-datum.

Regards,

Anirban

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 06:56:23 GMT

hi,

tried this.it definitely works.

REPORT ZEX_DATEVALIDATE .

Parameters p_date like sy-datum.

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.

Write:/ sy-subrc.

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

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

Validate the date

thanks,

shanthi.k

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 06:58:26 GMT

Hi,

Wat exactly you want to validate for date filed?

If you input any wrong data(including format) in the date field, system will throw an error.

Thanks,

Sriram Ponna.

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 07:08:10 GMT

Hi,

As also said by others use the FM DATE_CHECK_PLAUSIBILITY:

If you are using a sekection screen than write it under the event at selection-screen on w_date, where w_date is your date field.

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 sy-subrc is 0 then the date field is valid otherwise show a message to enter date in correct format.

With luck,

Pritam.

Re: Date Field Validation

Former Member — Tue, 25 Nov 2008 07:12:18 GMT

HI sunitha,

Sriram has said rightly,

if you enter a wrong format system throws an error.

let us know what validation you are looking for.

regards

Ramchander Rao.K