Show date ?

[ashmitp869]

Hi there,

How to show the below date -

Like 12th Oct 2021 ? In qlikview textbox

[abhijitnalekar]

Hi @ashmitp869 ,

Please use below expression.

=date(MakeDate(year(now()),Day(date#('12/10','DD/MM')),Month(date#('12/10','DD/MM'))),'DD MMM YYYY')

Hope this helps you

[Vegar · Accepted solution]

If 'st', , 'nd', 'rd' and 'th'  is important for you then you could take a look at this community posting.

Solved: Re: Date (Square) Problem - Qlik Community - 1120811

I haven't tried the solution my self, but it looks like it will do the trick.