Using Start Point with Date-objects

[Former Member]

Hi Expert guys and girls!

I use the "Start" point to execute my BAPI "Salesorder GetList" / BAPI_SALESORDER_GETLIST.

In order to use this BAPI you have to define

1) Customer Number

2) Sales Org

and optionally I checked also

3) Document Date

4) Document Date To

I fill in the values for all the fields. Using formulas for all - which works fine otherwise.

My Date - formulas are designed to retrieve the last 3 months.

ad 3)

DVAL(DADD(NOW(),-3,'M'))

4)

DVAL(NOW())

(I added the DVAL in front, but still I do not get any effect)

Problem is now that the model retrieves ALL records for the logged in Customer No. and Sales Org. NOT limiting data to the specified date-interval. This takes a long time and is certainly not what I expected.

I run SP14 - anybody had any experience in SP15 - maybe it is a simple upgrade?

Or am I missing something in parsing the dates??

Best regards

Jakob Diness

[Former Member]

I got it to work with a little effort.

1) Try parse fixed-dates (e.g. 08.08.2008) as Start and End dates. When that works, replace first the Start date then the end-date with DADD formulas like DADD(NOW(), -3, 'M') and NOW() in the End-date for example (going three months back in the example).

2) Maybe you need to try with the Flex compiler instead of Flex 2 - since that was also not working for me in other cases. (Tools/Options/Compiler - change to Flex)

3) Otherwise - pls. let me know. I somehow got it to work in my customer model.

[Former Member]

thx,

[Former Member]

Hi

I have the same problem in SP15.

Did U slove this?

May be U can prupose some workarownd?

Thanks,

Ola

[Former Member]

Thx, but should it not work without using DADD then?

Or can you not parse a date without using DADD?

And is it fixed in SP15 for example?

[Former Member]

Hi,

DADD Formula is not working fine .It has bug.

Wait untill it fixed.

Regards,

Govindu