Date format - 31.03.2014 to 03/31/2014

I am encountering an issue of converting text field but containing date:

I need to convert the date e.g. 27.02.2013, 06.02.2013 to mm/dd/yyyy, eventually extracting only month and year e.g. Feb-2013.  I got Feb-2013 and Jun-2013 when using %b-%Y.  How can this be?  Can someone answer?  Thanks.  Joe

I am processing raw data, not wanting to manually fix in CSV…

@jjmbih wrote:

I am encountering an issue of converting text field but containing date:

 

I need to convert the date e.g. 27.02.2013, 06.02.2013 to mm/dd/yyyy, eventually extracting only month and year e.g. Feb-2013.  I got Feb-2013 and Jun-2013 when using %b-%Y.  How can this be?  Can someone answer?  Thanks.  Joe

Hi @jjmbih,

This post was moved to a different board that fits your topic of discussion a bit better. This means you’ll get better engagement on your post, and it keeps our Community organized so users can more easily find information.

As you’ll notice, your Topic is now in the Project Development Help and Advice board. No action is needed on your part; you can continue the conversation as normal here.

Cheers!