topic date function to convert to Calendar Date in QlikView

date function to convert to Calendar Date

Anonymous — Wed, 13 Jan 2016 16:11:00 GMT

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 — Wed, 13 Jan 2016 16:14:57 GMT

Hi,

This format should do it for you

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

Anonymous — Wed, 13 Jan 2016 16:17:43 GMT

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

MK_QSL — Wed, 13 Jan 2016 16:18:04 GMT

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

Anonymous — Wed, 13 Jan 2016 16:20:12 GMT

Thanks for quick response. That version works too