Jump to content

Calculated column using IF function

Elise Cuyvers

Recommended Posts

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


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.


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...