Calculated column using IF function

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!

Attachments

AttachmentSize
Image icon issue_iffunction.png458.31 KB

1 Comment

Could you provide some sample data for these columns?

Addy - Feb 12, 2019 - 3:46am ::
+ Add a Comment

(1) Answer

Login