Forum Discussion
FIRSTDATE() Error
"A date column containing duplicate dates was specified in the call to function 'FIRSTDATE'. This is not supported." I am trying to get the first outcome date for a referral. I have an OUTCOME ta...
You can use the logic in such a way that it gets the FirstDate if there is no blank value, something like
Calculated column = if(not(ISBLANK(YourColumn)),<FIRSTDATE application>,BLANK())
This was the formula will not break because of blanks and the values will also stay intact
If you share our sample dataset, a more precise version of the formula can be provided
Thankyou
Sorry it's not letting me paste in an example of the data.