Date

[smilingjohn]

HI ,

I want display when there is no date , for which iam trying to write the below expression ...

if (Date=null,0)

to which it is giving error in expression , Can someone please suggest me how to write this

Thanks in Advance

[tresesco]

Try like:

if (IsNull(Date),0)

Or,

If( Len(trim(Date))=0, 0)

[sunny_talwar]

Where are you trying to do this? Script or front end? Dimension or expression (if its in front end)?

[smilingjohn]

Front end it is an expression within the text object

[sunny_talwar]

Have you tried tresesco‌'s suggestions? May be doing that will resolve your issues

[Anil_Babu_Samineni · Accepted solution]

May be this, Because you are talking about Text object

If(IsNull(Date),0, Concat(Date,','))