topic Date comparison in Application Development and Automation Discussions

Date comparison

Former Member — Sat, 20 Feb 2010 08:28:43 GMT

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

Re: Date comparison

kesavadas_thekkillath — Sat, 20 Feb 2010 11:31:22 GMT

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

Re: Date comparison

Former Member — Sun, 21 Feb 2010 15:21:04 GMT

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.

Re: Date comparison

Former Member — Sun, 21 Feb 2010 22:22:18 GMT

Moderator message - Please see before posting - post locked