Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the date#() function instead of the date() function.
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