# JuliaDB, handling and transforming dates

**URL:** <https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346>\
**Category:** New to Julia\
**Created:** [January 14, 2020, 2:10pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346 "2020-01-14T14:10:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rna1990](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rna1990/32/10797_2.png) [@rna1990](https://discourse.julialang.org/u/rna1990)\
**Post date:** [January 14, 2020, 2:10pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/1 "2020-01-14T14:10:38Z")

</div>

Dear fellow julians,

Quick question: let’s say I have an IndexedTable object with a column :Date which contains strings in format “01-JUL-19”. What’s the best way to transform the column into proper Date type?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![joshday](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/joshday/32/368_2.png) [@joshday](https://discourse.julialang.org/u/joshday)\
**Post date:** [January 14, 2020, 2:49pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/2 "2020-01-14T14:49:58Z")

</div>

I’ve done things like this in the past:

```julia
julia> using IndexedTables, Dates

julia> t = table((x = ["01-JUL-19", "02-JUN-19"],));

julia> f(x) = Date(x, DateFormat("dd-uu-yy")) + Year(2000);

julia> transform(t, :x => :x => f)
Table with 2 rows, 1 columns:
x
──────────
2019-07-01
2019-06-02
```

---

<div class="post-metadata">

**Author:** ![rna1990](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rna1990/32/10797_2.png) [@rna1990](https://discourse.julialang.org/u/rna1990)\
**Post date:** [January 14, 2020, 8:11pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/3 "2020-01-14T20:11:37Z")

</div>

Thanks a lot for the quick reply!

---

<div class="post-metadata">

**Author:** ![Balinus](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/balinus/32/243_2.png) [@Balinus](https://discourse.julialang.org/u/Balinus)\
**Post date:** [January 14, 2020, 8:29pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/4 "2020-01-14T20:29:12Z")

</div>

Might be a good candidate for a stack overflow question? Simple question, simple direct answer.

---

<div class="post-metadata">

**Author:** ![rna1990](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rna1990/32/10797_2.png) [@rna1990](https://discourse.julialang.org/u/rna1990)\
**Post date:** [January 14, 2020, 8:33pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/5 "2020-01-14T20:33:16Z")

</div>

I understand. Sorry! Was unaware of posting rules.

---

<div class="post-metadata">

**Author:** ![Balinus](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/balinus/32/243_2.png) [@Balinus](https://discourse.julialang.org/u/Balinus)\
**Post date:** [January 14, 2020, 10:27pm UTC](https://discourse.julialang.org/t/juliadb-handling-and-transforming-dates/33346/6 "2020-01-14T22:27:45Z")

</div>

I meant that we should add this question on SO. Posting here is fine! Sorry for the confusion.