1 Reply Latest reply: Apr 17, 2012 4:59 PM by Calvin Francart RSS

    Month() function returning null values

    Calvin Francart

      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.

        • Month() function returning null values
          Calvin Francart

          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.