Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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',)))
unfortunately this code does not work even when removing the eighth note in addition
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')))