Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Month() function returning null values

Has anyone ever experienced an issue where Month() - or even Date(<field>,'MMM') is returning null values when doing an import?

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.

1 Reply
Not applicable

Month() function returning null values

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.

Community Browser