Date comparison

[Former Member]

Dear All,

I create done the bdc recording in that recording i have a one date field i have validate that field ,field date can not be less then 01.04.2009 if that is then i have to thrw the message in that

I am not able to do that comparison kindly help me to resolve this issue.

thanks

[kesavadas_thekkillath]

The flat file data will be having the date field, validate the entries after uploading the date.

[Former Member]

Hi Sandeep,

Suppose your file uploaded date variable is w_date_file(8) TYPE c.

You need to make both dates of type system date, and do the comparison.

DATA: w_date                         TYPE   d,
            w_comparison_date    TYPE   d,
            w_formatted_date(10) TYPE   c.

MOVE w_date_file TO w_date.
w_comparison_date = '20090401'.           "YYYYMMDD format

IF w_date LT w_comparison_date.
      MESSAGE ....
ELSE.
     "use write statement 
     WRITE w_date to w_formatted_date.
     PERFORM fill_bdc USING .... w_formatted_date ....
ENDIF.

Regards,

Nisha Vengal.

[Former Member]

Moderator message - Please see before posting - post locked