Robert Higgins Posted July 14, 2020 Share Posted July 14, 2020 I am trying to create a calculated column using the following function datediff("day", [Enter_date],datetimenow()). I get error says it does not recognize DateTimeNow. In user documentation this is a valid function. Link to comment Share on other sites More sharing options...
Julie Sebby Posted July 14, 2020 Share Posted July 14, 2020 Are you using a data connection with in-database data When you work with in-database data, you are limited to the functions of that data source. If that data source doesn't have DateTimeNow(), then you wouldn't be able to use it. When you bring the data into Spotfire, all Spotfire functions are available. Link to comment Share on other sites More sharing options...
Julie Sebby Posted July 15, 2020 Share Posted July 15, 2020 Would you upvote the solution please. Link to comment Share on other sites More sharing options...
Robert Higgins Posted July 16, 2020 Author Share Posted July 16, 2020 Thank you , that worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now