Forum Discussion

JpTall's avatar
JpTall
Frequent Visitor
5 years ago

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...
Need Help
Show and Tell
VijayP's avatar
VijayP
Community Champion
5 years ago

JpTall 

To get the outcome why can't you use Min() Function instead of FirstDate?!

JpTall's avatar
JpTall
Frequent Visitor
5 years ago

When I use MIN() it generates the 1st date from the entire table for each record in my new column (all the same date). But I want the first date from each referral in that table to be added into the column.

 

Usually the join works here. I have also removed dupliaces from the join column but it doesn't help.