# Str2date "01-JAN-2015"

**URL:** <https://forum.cloverdx.com/t/str2date-01-jan-2015/1623>\
**Category:** CloverDX Platform\
**Created:** [May 4, 2015, 12:00am UTC](https://forum.cloverdx.com/t/str2date-01-jan-2015/1623 "2015-05-04T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yichuansancun](https://avatars.discourse-cdn.com/v4/letter/y/8e7dd6/32.png) [@yichuansancun](https://forum.cloverdx.com/u/yichuansancun)\
**Post date:** [May 4, 2015, 12:00am UTC](https://forum.cloverdx.com/t/str2date-01-jan-2015/1623/1 "2015-05-04T00:00:00Z")

</div>

Hello -

How can I convert the string to date with the source format being “01-JAN-2015”?

I tried “dd-mm-yyyy” and “dd-mmm-yyyy” but no luck,

Perri

---

<div class="post-metadata">

**Author:** ![simaj](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@simaj](https://forum.cloverdx.com/u/simaj)\
**Post date:** [May 6, 2015, 7:05am UTC](https://forum.cloverdx.com/t/str2date-01-jan-2015/1623/2 "2015-05-06T07:05:31Z")

</div>

Hi Perri,

The Month has to be in capitals :

```auto

	$out.0.field1=str2date($in.0.field1, "dd-MMM-yyyy");

```

I hope this helps.

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [May 6, 2015, 10:34pm UTC](https://forum.cloverdx.com/t/str2date-01-jan-2015/1623/3 "2015-05-06T22:34:21Z")

</div>

More information on [date & time format patterns is available in CloverETL User’s Guide.](http://doc.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/date-and-time-format.html)