Formula in Structure

[A_lis]

Hello All,

I use to JQL filter question: "End Date" <= 4w AND "End Date" > now()      ----> the result is ok

So then I try to transale this question to Formula in Structure (when the condition (end_date <= "4W") and (end_date > now() is ok then light the "(*y)" ):

if
((end_date <= "4W") and (end_date > now());"(*y)") 

but the formula doesn't work. I don't get any result

[Egor Tasa [ALM Works]]

Hi @A_lis 

"4w" would not work in Structure Expr language. You'll need to use some alternative like DAYS_BETWEEN(end_date, now())<=28

Regards,
Egor Tasa

ALM Works