Skip to Content
avatar image
Former Member

As on Date in BEX

Hi Experts,

Please guide me to create a date field in bex as on date ..as currently report has start date and end date(Fiscal Period) but user wants only one date should be there and it extract data from the start..
for example A company has been created on 2002 then if i run the query today it will get the data from 2002 till today.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 08, 2017 at 12:35 PM

    so I guess you have range filter set on your fiscal period (from - to). as for FROMyou can set a input ready variable and for TO you can set a sap standard variable current fiscal period.

    https://help.sap.com/viewer/6da591e86c4b1014b43de329b9ffb859/7.01.18/en-US/3ab92341c045ef23e10000000a155106.html

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 09, 2017 at 01:53 AM

    Hi,

    How will you know that company A was created on 2002? What field is it? Any other details about your report? Did Koen answered your problem already?

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded