topic Re: Problem in date field comparison in Application Development and Automation Discussions

Problem in date field comparison

Former Member — Mon, 09 Aug 2010 17:32:57 GMT

Hi,

I have a field with length 10 and another field with data type DATS.

Now, I need to compare these two fields.

DATA : v1 type char10,

v2 type sy-datum.

v1 = 01.12.2010.

v2 = 01.01.2010

now I need compare the above two fields.But, they are of different data types.

So, could you please help me out, how to do this. Is there any possiblty to change character field into DATE type.

Thanks,

Sandeep

Moderator message: basic date conversion question, please search for information before asking.

locked by: Thomas Zloch on Aug 10, 2010 10:31 AM

Former Member — Tue, 10 Aug 2010 02:10:41 GMT

Hi,

It is better to compere variables with same data type.

Convert your character data to date, for this you can use concatenate.

Data v3 type sy-datum.

Concatenate v16(4) v13(2) v1+0(2) into v3.

Please make sure this is YYYYMMDD.

Regards,

Former Member — Tue, 10 Aug 2010 06:49:47 GMT

Hi,

Use the function module - FORMAT_DATE_4_OUTPUT to convert the date in the same format fro both the dates and then compare them.

Edited by: Sachin86 on Aug 10, 2010 8:52 AM

Former Member — Tue, 10 Aug 2010 07:25:19 GMT

Hi,

DATA : v1 type char10,

v2 type sy-datum.

DATA : v3 type char10.

Write: v2 to v3.

Now you can compare v1 with v3.

Hope this helps.