Date and Month Mismatch

[Naushad07]

Hi All,

I am trying to extract the month name from Date. This is what I tried in the load script

Date,

Month(Date) as MONTH

I have created a Listbox for Date and MONTH both in the dashboard. However, When I click on MONTH, it's picking up  dates from other months. I have attached a snapshot of two list boxes.

 Any suggestions on how to correct this?

I am getting the Date field from Google Analytics QlikSense Connector.

[sunny_talwar · Accepted solution]

Try this

Date#(Date, 'YYYYMMDD') as Date,
Month(Date#(Date, 'YYYYMMDD')) as MONTH