I need to use DATETIME_FORMAT two times in my IF formula, otherwise it won’t show the date correcty. The current formula that I am using is: IF({Execute day (before/after)}=BLANK(),{PROJECT DEADLINE},DATETIME_FORMAT(DATEADD({PROJECT DEADLINE},{Exec...