I want to apply a calculations as per below, the problem the date of blanks is defaulted as 1/1/1900 , I want to replace CaseDueDate with RequestedDate if it returns 1/1/1900
IF ISNULL([CaseDueDate]) THEN [RequestedDate]
ELSEIF ISNULL([RequestedDate]) THEN [CaseDueDate] END
10 answers
see the red tab
this will work in your case
ifnull(([Case Due Date]),[RequestedDate])
