topic Comparing DATES. in Application Development and Automation Discussions

Comparing DATES.

Former Member — Fri, 09 Feb 2007 20:46:47 GMT

Hi everyone , I`m trying to compare two dates , one of them is the field planfinish (type: DEC 15 ) of cgpl_task table in CRM , it has the format : 31.10.2006 03:59:00 , the other date is sy-datum. But I don`t know what can I do ? ,

For example the next select bring me all registers , it doesnt care about t1~planfinish > sy-datum condition .

SELECT t2_{objnr t1}guid t1_{external_id t1}planfinish t2~stat INTO TABLE ti_campaut

FROM cgpl_task AS t1

INNER JOIN crm_jest AS t2

ON t1_{guid = t2}objnr

WHERE t1~object_type = 'CPT'

AND t2~inact = ' '

AND t2~stat = 'I1122'

AND t1~planfinish > sy-datum .

any help. ?

Re: Comparing DATES.

Former Member — Fri, 09 Feb 2007 21:07:43 GMT

if you don't need the time stamp truncate the date with time stamp in the sy-datum format and compare.

Or else try other system fields like sy-uzeit.

concatenate sy-datum and sy-uzeit and use it in ur select

Message was edited by:

Vinni

Message was edited by:

Vinni

Re: Comparing DATES.

Former Member — Fri, 09 Feb 2007 21:52:02 GMT

hey is ur problem solved ? if yes award points and close the thread.

Re: Comparing DATES.

Former Member — Fri, 09 Feb 2007 22:06:39 GMT

Hi Ali,

Can you tell in which format the date is coming in field planfinish after writing select query?

e.g. 31102006 (DDMMYYYY) or 10312006 (MMDDYYY) etc.

If the date in palnfinish is coming in DDMMYYYY format the you need to check Date format of sy-datum. Most of the time it is YYYYMMDD. In this case before comparing you need to format the sy-datum field in another variable. e.g. Here sy-datum is in YYYYMMDD format.

DATA: v_date(8) TYPE c,

v_date2(15) TYPE c.

v_date4(4) = sy-datum0(4).

v_date2(2) = sy-datum4(2).

v_date0(2) = sy-datum6(2).

You can make v_date in same sequence as planfinish.

If palnfinish is having TIME also then declare another variable of length 15 & concatenate the v_date & sy-uzeit into that variable & then compare.

Concatenate v_date sy-uzeit into v_date2.

Now compare this v_date2 with palnfinish field.

Ashven