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

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.