Calculated Field using Timestamp Field
How can I get the data types to be compatible?
I am trying to using the calculated field:
Case when Intake Date <= rev_timein THEN Min(rev_timein) ELSE ‘0000-00-00 00:00:00’
But I keep getting an error that the data types aren’t compatible. Is there anyway to do this or to show NULL?