CONVERTING FROM STRING FORMAT TO DATE FORMAT

[dunkindonut7777]

Hi I would like to ask if how can I convert the unusual date that has a string type of data to date format.

Date (String)	Expected output (Date)
05-MAR-2018	2018-03-05
22-JUN-2018	2018-06-22

How can I convert it according to the date format? Thanks

[AngelosPachis · Accepted solution]

Hi @dunkindonut7777 ,

You can use a date time tool to do that, configured to convert a string to a date format.

The format should be set to custom and the expression is dd-Month-yyyy as shown above.

Hope that helps,

Angelos

[Ar13f · Accepted solution]

Dear @dunkindonut7777 

another way can use with "formula tool"

please see the attachment of my workflow ... hope this helps what you want..

[StephaneP · Accepted solution]

Hello @dunkindonut7777 ,

In complement here is a quick interactive video to discover the lovely Date Time Function: DateTime Functions 

Available with so many others in the Learn/Academy/ Interactive Lessons menu.

Hope it helps

[Ar13f]

Dear @StephaneP 

thanks for the info, i'll look into it for the session.