topic Comparing dates in Application Development and Automation Discussions

Comparing dates

Former Member — Mon, 25 Jun 2007 09:47:49 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_member378318 — Mon, 25 Jun 2007 14:26:16 GMT

Why are you using CONVERSION_EXIT_PDATE_OUTPUT' ?? surely the dates in lv_vkdbi and lv_vkdab are already in internal format as you require them for use in the select statement.

Re: Comparing dates

Former Member — Mon, 25 Jun 2007 14:33:16 GMT

Hi Praveen,

No need of using the conversion exit.The dateis already in internal format.

Thanks,

Kasi Raman R

Re: Comparing dates

Former Member — Mon, 25 Jun 2007 17:55:50 GMT

your code is correct.

> i am getting the condition record number if i remove

> the dates comparison.

Thats because the record does not lie in the date range. So, its not populating when the date comparision is done.

Regards

Navneet