Convert Date

[Former Member]

Hi,

In a FM 'J_1I6_DETERMINE_EXCISE_RATE', There is a statement 'CONVERT DATE date INTO INVERTED-DATE date_j'. the value of date is '20070813' and the date is converted to '79929186' in date_j.

If this date is converted, in the next select query in the FM is not picking up the record.

I wanted to get this select query pick the record from the table.

Can anybody tell me the logic behind this??.

Regards,

Sai

[Former Member]

Hi,

Declare a global variable of type sy-datum.

data: l_tempdate type sy-datum.

Before moving to the FM 'J_1I6_DETERMINE_EXCISE_RATE' save the data field into l_tempdate.

Now in the following select query use the date l_tempdate.

<b>Reward points if this helps,</b>

Kiran

[former_member378318]

There is nothing wrong with the logic of the function mudule you must be passing the wrong date. The date you are passing does not meet the selection criteria to return the record you want.

Check your input carefully.