Expression to filter rows with blank cell/no date

[Phil_Waite]

Hi,

I have a date column where some rows ahve a blank cell. This is so the app shows dd/mm/yyyy rather than “30/12/1899”

I have an expression to slice the data and filter out the rows with no date set but I can’t establish how to defien which ones have no date.

I have tried expressions below but nothing seems to work. How does appsheet view a date cell with nothing in it?

If i fill each cell with “0” and exclude them that way then I get the 30/12/1899 come up wich my sales team find distracting.

NOT([Next Call]=" ")

[Next Call]>TODAY()-1000)

thanks

phil

[Jonathan_S · Accepted solution]

Is an actual blank cell?

isnotblank([DateCell]) will filter out blank cells.

[Steve]

For reference:

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

ISNOTBLANK()

Is value present?

[Phil_Waite]

Thank you, that worked. Also had a problem with LOOKUP() so used ANY(SELECT and all good

cheers