Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.