topic Re: change of Date Format in QlikView

change of Date Format

Tue, 01 Oct 2013 14:32:57 GMT

I have created a text object with following code “=date(now()) “ which displays today’s date (01/10/2013).

But I want something like this: 01 October 2013. Can anyone tell me how to do it ?

Thanks

Tue, 01 Oct 2013 14:35:11 GMT

Try;

=date(Now(), 'DD MMMMMMM YYYY')

Tue, 01 Oct 2013 14:38:07 GMT

Excellent, Working fine.Thanks Steve!

lvf — Tue, 01 Oct 2013 16:10:36 GMT

Try to avoid using the now() function in the UI. The reason it that it will be evaluated every second.

Best practice if you wish to reference the date, use today() function instead.

date(today(), ' DD MMMMMMM YYYY')