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...
Gaia Paolini Posted February 11, 2019 Share Posted February 11, 2019 Hi it is most likely a data type problem. What is the error you are getting (hover on the red exclamation mark)In one case you are outputting the difference between a DateTime and a Time, which is a TimeSpan, else you are outputting an empty string. Also, I am not sure that if you compare a Time and a DateTime you ever get the outcome that the Time is greater than the DateTime. Gaia Link to comment Share on other sites More sharing options...
Aditya Singh 3 Posted February 12, 2019 Share Posted February 12, 2019 Could you provide some sample data for these columns 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