mattb
02/26/2020, 12:46 AMDECODE({item}, 'ItemName', {trandate}, NULL) (returns 24/02/2020)
However this does not?
DECODE({item}, 'ItemName', TO_CHAR({trandate},'DD/MM/YY') , NULL) (returns 30/12/19, no real idea how the date is being returned)