Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
2 years ago

Error when Passing parameter for date field

Hi all, I am using SAP BW Bex query as source. I have a date variable in the bex query. I am tying to pass (current date-7) as start date and current data as end date.   Variables in Bex...
Need Help
POSPOS's avatar
POSPOS
Post Partisan
2 years ago

lbendlin -  could you pls provide steps on how to achieve using the fake list out of a single value you mentioned,

lbendlin's avatar
lbendlin
Super User
2 years ago

- use Value.Is to check if the parameter is a list

- if it is not, encase it in curly brackets

  • POSPOS's avatar
    POSPOS
    Post Partisan
    2 years ago

    lbendlin  - I looked at the parameter type in the backend query and it is not a list. I have also enclosed in curly brackets and still get the same error

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Maybe post a less obfuscated version of your query?

      • POSPOS's avatar
        POSPOS
        Post Partisan
        2 years ago

        lbendlin  : I was now able to pass one parameter that I created.

        When I pass the second parameter "DatePar1", I get an error.

         



        Error:


        Can you please suggest.