topic Re: comparing dates in Application Development and Automation Discussions

comparing dates

Former Member — Mon, 25 Jun 2007 09:59:28 GMT

Hi,

I am working with promotion transaction WAK1.

My requirement is to select the condition record number from the table A017 by comparing the all the primary key fields.

in that i have date fields valid to date and valid end date .

i want to select the condition record number which will fall between the valid to date and from date of header promotion.

I am using DATBI GE lv_vkdbi

AND DATAB LE lv_vkdab.

lv_vkdbi and lv_vkdab are dates that i converted using CONVERSION_EXIT_PDATE_OUTPUT' of the header wakhd.

i am getting the condition record number if i remove the dates comparison.

Please help me in getting with dates comparison

regdards

pavee.

Re: comparing dates

Former Member — Mon, 25 Jun 2007 12:12:34 GMT

Hi,

check out the following link it might help you

http://help.sap.com/saphelp_webas620/helpdata/en/fc/eb3509358411d1829f0000e829fbfe/frameset.htm

****please reward points if the infromation is helpful to you***********

Re: comparing dates

Former Member — Tue, 26 Jun 2007 05:19:11 GMT

Hi Praveen,

Comparing Dates is similar to the comparison of remaining data types.

An example code can be as below:

Parameters: a type D, b type D.

if a EQ b.

Write 'EQUAL'.

elseif a GT b.

Write 'a is GREATER THAN b'.

else.

Write 'a is LESSER THAN b'.

endif.

The format of the Date field may vary from system to system. For ex. YYYYMMDD or DDMMYYYY.

Reward points for useful answers.

Regards,

Sumanth

Re: comparing dates

Former Member — Tue, 26 Jun 2007 10:24:46 GMT

Hi Praveen,

You can see the date format in the entries of A017. The Function Module CONVERSION_EXIT_PDATE_OUTPUT would not help in this case.

You would have to convert the dates to match with the format of A017.

For further help, do not hesitate to mail me.

Reward points if helpful.

Regards,

Atin

Re: comparing dates

anand_goenka — Mon, 16 Jul 2007 15:40:45 GMT

hi praveen_g,

try adding a condition in WHERE in ur SQL "and U_date between St_Date

and End_Date" where U_date is the date u want to compare and St_Date is starting date and End_Date is the ending date or last date....

regards,

Anand