Harper Johnson
02/25/2020, 10:08 PMcferber
02/25/2020, 10:11 PMKrish
02/25/2020, 10:33 PMFran
02/26/2020, 12:25 PMTodd
02/25/2020, 10:35 PMTodd
02/25/2020, 10:35 PMTodd
02/25/2020, 10:35 PMTodd
02/25/2020, 10:40 PMSimon
02/25/2020, 10:42 PMSteve82
02/25/2020, 10:43 PMTodd
02/25/2020, 10:45 PMmichoel
02/25/2020, 10:45 PMTodd
02/25/2020, 10:45 PMmichoel
02/25/2020, 10:45 PMTodd
02/25/2020, 10:45 PMTodd
02/25/2020, 10:46 PMNetSweat
02/25/2020, 10:58 PMMarygolds3
02/26/2020, 12:10 AMMarygolds3
02/26/2020, 12:11 AMmichoel
02/26/2020, 12:30 AMMarygolds3
02/26/2020, 12:30 AMMarygolds3
02/26/2020, 12:31 AMmattb
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)mattb
02/26/2020, 12:57 AMbattk
02/26/2020, 12:59 AMmattb
02/26/2020, 12:59 AMbattk
02/26/2020, 1:03 AMbattk
02/26/2020, 1:04 AMmattb
02/26/2020, 1:07 AMDECODE({item}, 'ItemName', TO_DATE({trandate},'DD-Mon') , NULL)
with either a text or date field nowmichoel
02/26/2020, 1:10 AMTO_DATE
is to convert a string to a date but {trandate}
is already a date.