topic Re: DATE VALIDATION in Application Development and Automation Discussions

DATE VALIDATION

Former Member — Tue, 28 Nov 2006 04:04:09 GMT

hi,

i am uploading text file from user containing date. i want to validate this date , how can i do that bcoz user can enter the date in various format.how can i do that?

regards

nilesh

Re: DATE VALIDATION

anversha_s — Tue, 28 Nov 2006 04:06:08 GMT

hi,

use this.

DATA: v_date TYPE sydatum.
 
CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'
EXPORTING
date = v_date
EXCEPTIONS
plausibility_check_failed = 1
OTHERS = 2.
IF sy-subrc <> 0.
WRITE: / 'INvalid date'.
ELSE.
WRITE: / 'Correct date'.
ENDIF.

rgds

anver

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 04:09:02 GMT

chk this thread

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 04:12:00 GMT

Check this...

DATA: v_char(6).

v_char = '121706'.

DATA: v_date TYPE sydatum.

v_date+4(2) = v_char(2).

v_date6(2) = v_char2(2).

CONCATENATE '20' v_char+4(2) INTO v_date(4).

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'

EXPORTING

date = v_date

EXCEPTIONS

plausibility_check_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

WRITE: / 'INvalid date'.

ELSE.

WRITE: / 'Correct date'.

ENDIF.

Re: DATE VALIDATION

anversha_s — Tue, 28 Nov 2006 05:24:04 GMT

hi,

<b><i>hope ur issue solved.

if so pls close the thread after marking all helpful answers,</i></b>

rgds

Anver

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 05:43:28 GMT

good

try this function moudle

DATE_CHECK_PLAUSIBILITY Check to see if a date is in a valid format for SAP. Works well when validating dates being passed in from other systems.

thanks

mrutyun^

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 06:28:57 GMT

i am passing the value 28112006 but still this function returns invalid date(sy-subrc=1), which date format should i pass.

regards

martin

Re: DATE VALIDATION

anversha_s — Tue, 28 Nov 2006 06:30:30 GMT

hi,

did u check my post.

just pass sydatum type

rgds

Anver

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 06:35:11 GMT

ya i am passing value using a variable of type sy-datum though it is not working.

always gives me sy-subrc = 1.

regards

martin

Re: DATE VALIDATION

Former Member — Tue, 28 Nov 2006 07:02:58 GMT

try to pass this as a parameter .

this should be like ur user settings date .

like mm/dd/yyyy or mm.dd.yyyy

since u r referring to type sy-datum in the selection screen itself if u pass a wrong format this will throw an error .

execute the code ..


parameters : p_datum like sy-datum.

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'
EXPORTING
date = p_datum
EXCEPTIONS
plausibility_check_failed = 1
OTHERS = 2.
IF sy-subrc <> 0 .
WRITE: / 'Wrong format in date'.
ELSE.
WRITE: / 'Correct date'.
ENDIF.

regards,

vijay