Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lubicz99
Valued Contributor

date function to convert to Calendar Date

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?

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: date function to convert to Calendar Date

Hi,

This format should do it for you

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

View solution in original post

4 Replies
Partner
Partner

Re: date function to convert to Calendar Date

Hi,

This format should do it for you

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

View solution in original post

lubicz99
Valued Contributor

Re: date function to convert to Calendar Date

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

MVP
MVP

Re: date function to convert to Calendar Date

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

lubicz99
Valued Contributor

Re: date function to convert to Calendar Date

Thanks for quick response.  That version works too