CASE WHEN lastsaledate = TO DATE 2018 01 01 YYYY MM DD THEN NetSuite Professionals #administration

CASE WHEN ({lastsaledate})=(TO_DATE('2018-01-01', ...

Dakotah_NSC

07/03/2020, 12:17 AM

CASE WHEN ({lastsaledate})=(TO_DATE('2018-01-01', 'YYYY-MM-DD')) THEN 'CURRENT' ELSE 'OLD' END

battk

07/03/2020, 12:30 AM

looks reasonable for a text formula, whats wrong with it?

2 Views