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
lbendlin's avatar
lbendlin
Super User
2 years ago

what happens when you use

 

{ DatePar, DatePar1 }
POSPOS's avatar
POSPOS
Post Partisan
2 years ago

lbendlin  - changed the code as below.

Error:

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    What date format is your BW expecting? ISO8601?

  • POSPOS's avatar
    POSPOS
    Post Partisan
    2 years ago

    lbendlin  - This is the date format which works in BW.

    Even in Power BI , the format is same:

     

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    these are not the same formats.  (and neither are good formats).  Can you specify the date in ISO8601?

  • POSPOS's avatar
    POSPOS
    Post Partisan
    2 years ago

    lbendlin  : changed the format :


    I get the below error:

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    That's a datetime.  You need to convert to datetime first and then to date.

     

    But I am disappointed that SAP BW can't handle this natively.

  • POSPOS's avatar
    POSPOS
    Post Partisan
    2 years ago

    lbendlin  - I get the same issue as previously mentioned with date type as well.