Help to format a calculation on dates

[Lene]

Totally new to Qlik Sense 🙂

I have build a calculation in the Expression builder:

=if([Actual Finish Date]>0,'',[Deadline Date])

However the [Deadline Date] is showed as  43465 and I wanted to have it shown as 31-Dec-2018.

What do I do?

[Zhandos_Shotan]

Hi!
try:
=if([Actual Finish Date]>0,'',Date([Deadline Date],'DD-MMM-YYYY'))

regards

[Lene]

THANKS, it works 🙂