topic Re: Help to format a calculation on dates in App Development

Help to format a calculation on dates

Lene — Sat, 16 Nov 2024 06:22:34 GMT

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 — Sun, 10 Mar 2019 18:35:27 GMT

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

regards

Lene — Sun, 10 Mar 2019 18:48:03 GMT

THANKS, it works 🙂