would anyone know why in a transaction saved searc...
# general
m
would anyone know why in a transaction saved search this returns the correct date:
DECODE({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)