COlor Expression

[Lee1]

hello 🙂

I would like to apply a color code in the editor expression

If (date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')> = '0', 'green',
If (date (date1], 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD') <'0', 'orange',
If (date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD') = '', 'red',)))

curiously the red color when empty does not appear do you have a formula?

[Chanty4u]

can you try this?

If (date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')> = '0', 'green',
If (date (date1], 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD') <'0', 'orange',
If (isnull(date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')) = '', 'red',)))

[Lee1]

unfortunately this code does not work even when removing the eighth note in addition

[Aranyatejan]

Try this:

Dimension:

IF(isnull((date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')),'Undefined',(date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD'))

Expression

If (date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')> = '0', 'green',
If (date (date1], 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD') <'0', 'orange',
if(If (isnull(date (date1, 'YYYY-MM-DD') - date (date2, 'YYYY-MM-DD')),'Undefined' )='Undefined', 'red')))