Re: [julia-users] Changing the year in two digit year using DateTime

[Tamas Papp]

Try something like

function dateYY(d)
    y = Dates.year(d)
    if 70 <= y <= 99
        d+Dates.Year(1900)
    elseif 0 <= y <= 20
        d+Dates.Year(2000)
    else
        error(@sprintf("don't know what to do with year %d", y))
    end
end

eg

dateYY(DateTime("96/15/03", "yy/dd/mm"))
dateYY(DateTime("00/15/03", "yy/dd/mm"))
dateYY(DateTime("19/15/03", "yy/dd/mm"))
dateYY(DateTime("70/15/03", "yy/dd/mm"))

Cutoffs would depend on your dataset.

Best,

Tamas

On Tue, Jun 14 2016, akrun wrote:

> Hi,
>
> If I have a vector of dates
>
>    v1 = ["96/15/03", "15/15/03"]
>
> Using DateTime, it gives
>
>     DateTime(v1, "yy/dd/mm")
>     #2-element Array{DateTime,1}:
>     #0096-03-15T00:00:00
>     #0015-03-15T00:00:00
>
> How do I get
>
>      1996-03-15T00:00:00 and 2015-03-15T00:00:00
>
> Thanks