Comparing dates

[Former Member]

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.

[former_member378318]

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.

[Former Member]

Hi Praveen,

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

Thanks,

Kasi Raman R

[Former Member]

Hi

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