I want to use a rolling date formula like this:

I want to use a rolling date formula like this:

Last_date > CONVERT(VARCHAR(8),DATEADD(mm, -24, getdate()),112)

 

I added this to the SQL from the information link view.  Saved it and it ran successfully until I saved the analysis and closed.  I was unable to reopen and received this error.

 

Error message: Could not open information link.

InformationModelException at Spotfire.Dxp.Data:
Failed to get data: An error occurred while converting the varchar value to JDBC data type TIMESTAMP. (HRESULT: 80131500)

 

I removed the sql and reset to origional in the information link.  The data was able to load from the link view, but still the library will not open. 

 

Any ideas how to clear this from the library?

Any ideas how to create the rolling date? 

 

 

(1) Answer

Login