Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Month function in expressions

Hi, I have date filed as

1/29/2014

3/22/2014

7/15/2014

5/23/2014

12/24/2014

I am trying to extract Month in a list box expressions, But I am not getting as needed

Month(Date(Apld_Dt, 'DD/MM/YYYY'))

Month (Apld_Dt)


As a result I am getting as x -

Please advise



2 Replies
oknotsen
Honored Contributor III

Re: Month function in expressions

Use the date#() function instead of the date() function.

May you live in interesting times!

Re: Month function in expressions

Yup like Onno van Knotsenburg‌ said, may be you need to tell QlikView that this is a date. And you can do that using Date#() function:

Month(Date#(ApId_Dt, 'M/D/YYYY')) as Month