Spotfire date expression error -


in spotfire have column property fromdate , todate date. trying limit result of data using expression below. keep on encountering error

invalid type function call 'documentproperty' on line1, character 19 

limit expression

[poddate] >= date(documentproperty(${devinfoytd}.{location}.{fromdate})) ,  [poddate] <= date(documentproperty(${devinfoytd}.{location}.{todate})) 

if used below expression don't error there no data shown on table.

[poddate] >= date(${devinfoytd}.{location}.{fromdate}) , [poddate] <= date(${devinfoytd}.{location}.{todate}) 

any ideas on how fix it?

you don't need 3 part identifier. i'm unsure of supposed be, need list property control.

[poddate] >= date("${yourpropertycontrolname}") , and [poddate] <= date("${yourotherpropertycontrolname}") 

Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -