How to pass date parameter in SAS Visual Analytics

[Azeem112]

Dears,

I'm working on a report that has a date parameter.

There is a calculated field as

IF ( 'date'p <= 'date_of_offense'n )
RETURN 'Open'
ELSE 'Close'

Now I'm trying to pass this date parameter via URL but the report isn't picking the date value from the URL.

to even test it, I created a control dropdown of data_of_offense date column and assigned the date parameter in role tab. 

 

but whenever I send parameter via URL, the report doesn't update the value of the parameter from URL and also don't set the value of dropdown control, instead it does all the calculation using the default value of parameter that is 1Jan1960.

Below is the URL 

http://sasbap.demo.sas.com/SASVisualAnalyticsViewer/VisualAnalyticsViewer.jsp?reportPath=%2FShared%2...

I've tried many formats like 

date='12Jun2014'd

date=06/12/2014

date=12/06/2014

date=2014-06-12

date=2014-6-12

date=2014/06/12

date='06/12/2014'D

but report is not assigning the value of date parameter from URL to parameter. 

How can I pass the date value to the date parameter in SAS VA from URL. any help is appreciated.

Thanks.

[Sam_SAS · Accepted solution]

Hello,

I believe that the date value must be expressed as a numeric. The dates in VA are "SAS Dates", the number of days since 01JAN1960.

Try date=19886 to specify 12JUN2014.

You might find this page useful:

https://www.sastipsbyhal.com/2012/01/sas-date-calculator-now-available.html

You appear to be using VA 7.x? On Viya we have a URL generator UI that enables you pick the parameter values.

Sam

[Azeem112]

Thanks, It's working