If, greater than and less than

[D19PAL]

Hi 

This works 

If(isnull(date),networkdays(date2,today()))>16,1,0) as higher 

This doesn't 

If(isnull(date),networkdays(date2,today()))>16,)If(isnull(date),networkdays(date2,today()))<56,1,0) as higher_lower 

I've tried ' or'and 'and'

Thanks

[abhijitnalekar]

Hi @D19PAL ,

Try below.

If(isnull(date),networkdays(date2,today())>16 and (isnull(date),networkdays(date2,today()))<56,1,0)

[D19PAL]

The syntax is giving me an error.

[abhijitnalekar · Accepted solution]

If(networkdays(date2,today())>16 and networkdays(date2,today())<56,1,0)

Try above.

Do you have null in the date field?

[D19PAL]

That works, no I don't have null in date, do I need to add it? And why and how.

Thanks

[D19PAL]

I've got it working, I nested it underneath another if isnull statement.

[abhijitnalekar]

Great!!!!