Hi, I have date filed as
I am trying to extract Month in a list box expressions, But I am not getting as needed
As a result I am getting as x -
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
Retrieving data ...