You can try to use `TO_CHAR(TO_DATE({inventorydeta...
# suiteanalyticsc
Christiaan
02/20/2020, 12:36 PMYou can try to use
TO_CHAR(TO_DATE({inventorydetail.inventorynumber},'YYYYMMDD'),'DD/MM/YYYY')m
Mrudul
02/20/2020, 12:45 PMERROR: Invalid Expression
c
Christiaan
02/20/2020, 12:55 PMWhat is your formula type?
m
Mrudul
02/20/2020, 12:56 PMtext
Mrudul
02/20/2020, 12:56 PMdate does give same error
c
Christiaan
02/20/2020, 12:58 PMText should be fine
m
Mrudul
02/20/2020, 1:16 PMstill same error.