topic Month() function returning null values in QlikView https://community.qlik.com/t5/QlikView/Month-function-returning-null-values/m-p/356107#M705079 <HTML><HEAD></HEAD><BODY><P> Never mind - I found out the problem was how Excel is displaying the raw data - it is displaying dates that have only month, day, year and hour/minute (in 24 hour format) as month, day, year, hour/minute/seconds, and throwing in AM and PM to boot. Used Date#() to set the format and wrapped it with Month to get the actual month name.</P></BODY></HTML> Tue, 17 Apr 2012 20:59:18 GMT 2012-04-17T20:59:18Z Month() function returning null values https://community.qlik.com/t5/QlikView/Month-function-returning-null-values/m-p/356106#M705078 <HTML><HEAD></HEAD><BODY><P>Has anyone ever experienced an issue where Month() - or even Date(&lt;field&gt;,'MMM') is returning null values when doing an import?</P><P>I had it working, using data I am pulling in from a single excel file, where the date format in the column is M/D/YYYY hh:mm - but after making some changes to the file, it no longer imports - I get nothing but nulls.</P></BODY></HTML> Tue, 17 Apr 2012 20:19:19 GMT https://community.qlik.com/t5/QlikView/Month-function-returning-null-values/m-p/356106#M705078 2012-04-17T20:19:19Z Month() function returning null values https://community.qlik.com/t5/QlikView/Month-function-returning-null-values/m-p/356107#M705079 <HTML><HEAD></HEAD><BODY><P> Never mind - I found out the problem was how Excel is displaying the raw data - it is displaying dates that have only month, day, year and hour/minute (in 24 hour format) as month, day, year, hour/minute/seconds, and throwing in AM and PM to boot. Used Date#() to set the format and wrapped it with Month to get the actual month name.</P></BODY></HTML> Tue, 17 Apr 2012 20:59:18 GMT https://community.qlik.com/t5/QlikView/Month-function-returning-null-values/m-p/356107#M705079 2012-04-17T20:59:18Z