Hi Guys, I want to show text '0 to 30 days' when the date difference is less than 30 days. I'm using Formula(Text) for that but it is giving me Invalid Expr. Please help me here!!!

else 0

is wrong.

case

statements have to return the same datatype, so you need

else ''

. Also make sure you use single quotes around the first string

that works, thanks PNJ!

You're welcome