When I write a code "month(fv!item.asDate) = local!month", why it's showing a result A null parameter has been passed. How to resolve that part?
Also I put that part
if( a!isnullOrEmpty(index(fv!item, "asDate", null)), false, contains( tointeger(local!month), month(index(fv!item, "asDate", null)) ) ),
but same error as it is
Discussion posts and replies are publicly visible
You need to first check that the date you are passing in month() is not null, add an if condition to it.
if( isnull(fv!item.asDate), false, month(fv!item.asDate) = local!month )
No, it's not working. same error also showing
Are you sure that the error is due to month() only? Can you post screenshot of the error?
This the error
Please don't use isnull(). It was never a safe option. Instead, go for a!isnullorempty() should cover more usecases.
if( a!isnullOrEmpty(index(fv!item, "asDate", null)), false, contains( tointeger(local!month), month(index(fv!item, "asDate", null)) ) )
I already used that one, but it's not resolved, bcz same error occurred. plz suggest another way
Ikr, I was just showing how to do null handling and as far as compatibility concern, I assumed it was just a primitive type (date field), so will not disappoint but it seems like top level of null handling is also not applicable to this data. moulikadas can you please share the data you are using in items?
and the "asDate" is Date types. but it's not working. plz suggest some another way.