https://community.qlik.com/t5/App-Development/Date-and-Month-Mismatch/m-p/1642520#M47901 <P>Try this</P><LI-CODE lang="markup">Date#(Date, 'YYYYMMDD') as Date, Month(Date#(Date, 'YYYYMMDD')) as MONTH</LI-CODE> Mon, 04 Nov 2019 12:43:44 GMT sunny_talwar 2019-11-04T12:43:44Z https://community.qlik.com/t5/App-Development/Date-and-Month-Mismatch/m-p/1642514#M47898 <P>Hi All,</P><P>I am trying to extract the month name from Date. This is what I tried in the load script</P><P><STRONG>Date,</STRONG></P><P><STRONG>Month(Date) as MONTH</STRONG></P><P>I have created a Listbox for <STRONG>Date</STRONG> and <STRONG>MONTH</STRONG> both in the dashboard. However, When I click on MONTH, it's picking up&nbsp; dates from other months. I have attached a snapshot of two list boxes.</P><P>&nbsp;Any suggestions on how to correct this?</P><P>I am getting the&nbsp;<STRONG>Date</STRONG> field from Google Analytics QlikSense Connector.</P> Sat, 16 Nov 2024 19:45:50 GMT https://community.qlik.com/t5/App-Development/Date-and-Month-Mismatch/m-p/1642514#M47898 Naushad07 2024-11-16T19:45:50Z https://community.qlik.com/t5/App-Development/Date-and-Month-Mismatch/m-p/1642520#M47901 <P>Try this</P><LI-CODE lang="markup">Date#(Date, 'YYYYMMDD') as Date, Month(Date#(Date, 'YYYYMMDD')) as MONTH</LI-CODE> Mon, 04 Nov 2019 12:43:44 GMT https://community.qlik.com/t5/App-Development/Date-and-Month-Mismatch/m-p/1642520#M47901 sunny_talwar 2019-11-04T12:43:44Z