Date loses formatting when used in calculated dimension

[JustinDallas]

Hello Everyone,

I have a table where I am using a calculated dimension.  When I place in the dimension the plain field, I find that the Table works.  When I add a condition to the dimension, I get that Qlikview timestamp thing i.e 460232.435242

Images:

Working

Not Working:

What exactly is going on here? And how do I get it to keep my formatting.

Any help is greatly appreciated.

[OmarBenSalem]

Try to format it as date (timestamp):

[JustinDallas]

How are you getting to that part of the UI?  All I see is this.

[OmarBenSalem · Accepted solution]

you won't get it if your column is a dimension, do this instead:

if(Type='PUP',timestamp("Actual arrival"),null())