date function to convert to Calendar Date

[Anonymous]

Greetings,

Hopefully this will be an easy one.  I looked through the forum and could not find the quick fix.

I am using NPrinting and would like to insert today's date on my cover page of my report.  This is the same logic as creating a text box in Qlikview.

my formula is simple  

=today() and it returns 1/13/2016.   I would like it to return January 13, 2016

what is the format for the date() command to make this work in Qlikview?

[Gabriel · Accepted solution]

Hi,

This format should do it for you

=Date(Today(),'MMMM, DD, YYYY')

[Anonymous]

Yes it does.  Thanks for your quick response.  I could not find that verbiage in any of the threads I looked through.

[MK_QSL]

Date(Date#(Today(),'M/DD/YYYY'),'MMMM DD, YYYY')

[Anonymous]

Thanks for quick response.  That version works too