topic Expression in App Development

Expression

Lhelpqlik — Thu, 18 Jan 2024 15:01:08 GMT

Hi all,

I have a table below and I wish to remove the date/time -> 29/12/1899 00:00:00 but keep the other timestamps:

Wondering what would be the expression to use so that the incorrect timestamp is remove but shows either nulled or - instead?

Anil_Babu_Samineni — Thu, 18 Jan 2024 15:05:37 GMT

@Lhelpqlik I always dig into this way

If(Len(TimeStamp(Fieldname))>0, 'True', 'False')

It means, If there is any result with False then there will be wrong data entered, based on flag you can exclude them.

rwunderlich — Thu, 18 Jan 2024 20:14:40 GMT

29/12/1899 00:00:00 indicates the underlying value is 0. So to exclude in the load script you could add a where clause to the Load:

where [Balance Planned Date] <> 0

To remove from the chart you could use a set expression like:

Only({<[Balance Planned Date]={">0"}>}[Balance Planned Date])

-Rob