I’m working on a project where I’m trying to see if an event happening earlier (event a vs b) affects outcome x. I need to compare date a to date b. I am trying to use the Calculated Field to auto populate a response depending on if a or b happened earlier. Anyone have any suggestions on how I can do this? Thanks!
I tried “if/then” commands and it did not work. I also tried datediff and was hoping to set up dif answers depending on if the datediff is positive or negative, but that also didn’t work.
Sylwia B is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.