Is the DateTimeNow() when working with MS SQL Server datasource

[Balakumar Krishnasamy]

Hi All,

 

I am using MS sql server as datasource for my dashboard ,

When Im trying to use Year(DateTimeNow()) , it s not working ..

doesanyone know the reason

[Shashank Gurnalkar]

Hello Krish,

 

It looks like you are using in-db data(External data). Functions like DateTimeNow() are Spotfire specific functions and when the data is kept external, we cannot use them. Please refer the following manual for more information.

 

Reference:https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_working_with_in-database_data.htm

[Balakumar Krishnasamy]

Thanks for the answer. It is a great info. I was wondering what went wrong..