Elise Cuyvers Posted February 9, 2019 Share Posted February 9, 2019 Hi, I'm trying to create a calculated column using a simple if function. If TOBT (which is a Time) is bigger than Scheduled Time (which is a Datetime); substract TOBT from Scheduled Time, else do nothing (leave it empty). (see screenshot) However, it doesn't seem to work. I don't think the difference in datatype is of any issue, but with the expression language. Hope someone could help me out. Thank you in advance! Link to comment Share on other sites More sharing options...
Sayali Patil Posted February 12, 2019 Share Posted February 12, 2019 Hello, Try using the spotfire datediff function to find the difference between 2 dates,like- If(DateDiff('day', [date1], [date2]) > 1,DateDiff('day', [date1], [date2]),0) 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