Expression

[Lhelpqlik]

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]

@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]

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