This content has been marked as final. Show 4 replies
I have a table containing a Product Code , a Transaction Type and Date associated with the Transaction Type. There could be multiple Instances of the Transaction Type by date.
|Product Code||Date||Transaction Type|
I want to return the latest RECP Date i.e. 27/09/2017 but, if there is no RECP then return the latest ADJ. 01/10/2017
How can I achieve this in a IF THEN statement