Forum Discussion
Solved
DATEDIFF and IF
I am trying to add 7 days to the "Task Completion Date" if the "Task Status" is = CONCOMP which gives me the "GF Job Card Due Date" column. Thank you. GF Job Card Due Date = IF(DATEDIFF( ...
Ok got it fixed and attached what I got it to. Thanks for your help.
This kind of worked but showing the date as 12/31/9999 for some reason. I did change the first one just a little and got what I am showing. The second one had the same outcome exect dates in all the fields even when not = to CONCOMP and again the dates were 12/31/9999
Ok got it fixed and attached what I got it to. Thanks for your help.