Month function in expressions

[#1]

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

[oknotsen]

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

[sunny_talwar]

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