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:


I get an errror as below when I use the code.

Can someone please suggest on how to fix this?

Thank you.

Need Help

14 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Read about Value.Is   and then adjust your Power Query code to account for both scenarios.  Easiest approach is to make a fake list out of a single value and then tailor the Bex query for lists.

    • 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