Cannot `convert` an object of type DataValues.DataValue{Any} to an object of type DateTime about datavalues.jl

[IanButterworth]

Here's a concise example for testing:

using DataFrames, Dates, ExcelFiles
filename = "test.xlsx"
df = DataFrame(load(filename, string("Sheet1!A1:E25"),header=true))
df[:DateTime] = convert(Vector{Union{DateTime, Missing}},df[:DateTime])

And source excel file: https://www.dropbox.com/s/cwq5m6m9179s57a/test.xlsx?dl=1

[IanButterworth]

I've written a temporary function to fix the columns:

function fixcolumn(col,T)
    arr = Vector{Union{Missing, T}}(0)
    for x in col
        try
            push!(arr,x.value)
        catch
            push!(arr,missing)
        end
    end
    return arr
end

For instance:

df[:DateTime] = fixcolumn(df[:DateTime],DateTime)