topic date format check in Application Development and Automation Discussions

date format check

Former Member — Thu, 19 Jul 2007 06:24:34 GMT

i want to check the date format how can i?

2007/09/23 like this format or not

Re: date format check

Former Member — Thu, 19 Jul 2007 06:27:19 GMT

If it is a report you can put a break-point where ever that field is being poputaled and check in debugger.

Regards,

Himanshu

Re: date format check

Former Member — Thu, 19 Jul 2007 06:28:18 GMT

Check the date related fun modules

CONVERT_DATE_TO_INTERNAL

CONVERT_DATE_TO_EXTERNAL

CONVERT_FIELD_TOEXTERN_FORMAT

Reward points for useful Answers

Regards

Anji

Re: date format check

Former Member — Thu, 19 Jul 2007 06:28:21 GMT

HI,

you can try like this,

first validate the year

date+0(4) should be greater and 1000 and less than 9999

and date+4(1) = '/'.

and date+5(2) should be between 01 and 12

and date+7(1) = '/'.

and date 8(2) should be between 01 and 31.

if any one of these conditions are failed

then your date format is wrong.

reward points if helpful,

thanks & regards,

venkatesh

Re: date format check

former_member189059 — Thu, 19 Jul 2007 06:29:51 GMT

Hello Ramesh,

Using sub-strings you can check for the position of the '/' character

eg... if field+2(3) = '/'.

Re: date format check

amit_khare — Thu, 19 Jul 2007 06:30:45 GMT

Refer the link -

Regards,

Amit

Reward all helpful replies.

Re: date format check

Former Member — Thu, 19 Jul 2007 06:32:29 GMT



DATA: e_date(10) type c VALUE <b>'02/02/2006',</b>" specify wrong date format here
i_date(10).

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
EXPORTING
date_external = e_date
IMPORTING
date_internal = i_date
EXCEPTIONS
date_external_is_invalid = 1
OTHERS = 2.


case sy-subrc.

when 0.
WRITE : / 'CONVERT_DATE_TO_INTERNAL',
/ 'My Date:' , e_date ,
'Conv Date:', i_date,
'System Date:', sy-datum.

when 1.
<b>write: 'date_external_is_invalid'.</b>

when 2.
write:' some error occured'.
endcase.

regards

ravish

plz dont forget to reward points if helpful

Re: date format check

Former Member — Thu, 19 Jul 2007 06:32:37 GMT

HI Ramesh

try like thi s

 data: begin of int_bseg occurs 0,
    BELNR LIKE BSEG-BELNR,
    ZUONR LIKE BSEG-ZUONR,
    GJAHR LIKE BSEG-GJAHR,

end of int_bseg.
start-of-selection.
data: lv_date type sy-datum.
data: lv_date1 type sy-datum.

data: lv_formatdate(10) type c.
data: lv_formatdate1(10) type c.

data: var1(4) type c,

var2(2) type c,

var3(2) type c.


data: 2days_out type sy-datum.


lv_date = 2days_out.
var1 = lv_date+(4).
var2 = lv_date+4(2).
var3 = lv_date+6(2).

concatenate var3 var2 var1 into lv_formatdate separated by '/'.

select zuonr belnr bukrs GJAHR from bseg into
corresponding fields of  table int_bseg
where bukrs = 'company code' and
      ZUONR = lv_formatdate.

Reward all helpfull answers

Regards

Pavan

Re: date format check

Former Member — Thu, 19 Jul 2007 06:34:14 GMT

Function Module is ->DATE_CHECK_PLAUSIBILITY for

Date plausibility check

reward points if it is usefull.

Girish

Re: date format check

Former Member — Thu, 19 Jul 2007 06:35:38 GMT

Hi,

Use CP (ContainPattern) as below :

if Date CP '//*'.

statement....................

endif.

reward points, if helpful,

sandeep kaushik