Date Picker Giving Error

[Former Member]

Hi,

I have started exploring VC. I have a BI query which has a required date field as a variable. I have put Date picker at the input form dragged from variable port. When I deploy and select the date from date picker and try to get required data I get the error

Can not execute BW query: Nested Exception.failure to execute

native function. Nested Exception:

Invalid_Variable_Value.

I have given Assigned value as 'text' to the submit line joining query input and input form because the respective value (@xyzdate) was not coming in the drop down of assigned column. Its urgent. Points will be assigned to correct solution.

Cheers,

Jayant

[Former Member · Accepted solution]

Hi Jayant,

did you use the function DSTR(date,mask) in "Assigned Value" to format the date as text? By defining the mask you can format the date exactly the way your query needs it. For examle DSTR(@xyzdate,MM.YYYY) would return the date as text in format 12.2007.

To learn more about the syntax, take a look at this <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/decad990-0201-0010-8d99-ec411c60decc">Visual Composer Expressions Syntax</a> document.

Best regards, Benni