Converting Date Time

[henrymk5]

I'm having a hard time converting the following date time format. Hoping that someone could assist me.

2020-4-26 to Apr20

Thank you 🙂

[BrandonB]

The DateTime tool should help you to do this using the custom format of Monyy

 

[henrymk5]

Hi Brandon,

It does not match the exact format as my use case.

I have 2020-4-27 and your sample is 2020-04-27.

Are you still able to resolve using the format from my sample?

Thank you !

[BrandonB · Accepted solution]

Yep! Even though your data looks like it is a date, technically it isn't in a date data type yet. You can use one date time tool to format to take your date in a string and convert it into an official date data type, and then use another date time tool to bring it back into a string in whatever format you would like. 

 

[Bennel_Wilson · Accepted solution]

Hi @henrymk5 ,

Let me know if this works for you.

Regards

Benn

P.S: In case this solves your query, kindly mark this as a solution.

[henrymk5]

Thank you this works!! I appreciate it 🙂