JamesWarren
3 years agoQrew Trainee
Using a date in an If statement
I want to write a fairly basic If statement that would look something like this:
If([Resolution Date] > (3+[Initiation Date], "TRUE", "FALSE)
However, I receive the error "Expecting bool but found date".
Are dates able to used in this way? Are there any possible workarounds I could explore?
Thank you!
------------------------------
James Warren
------------------------------
If([Resolution Date] > (3+[Initiation Date], "TRUE", "FALSE)
However, I receive the error "Expecting bool but found date".
Are dates able to used in this way? Are there any possible workarounds I could explore?
Thank you!
------------------------------
James Warren
------------------------------