Choose Language Hide Translation Bar

Re: How to convert character formats to date format

No, not out of turn at all... My VBA is just really weak  ... sticking to my strengths here!

Highlighted
DS
DS
Level VI

Re: How to convert character formats to date format

Hi @MikeD_Anderson,

 

  I was having a similar issue as the original post did, but more with converting a date format from German style: dd.mm.yyyy to mm/dd/yyyy.

 

  I tried the InFormat() approach, but it didn't work, whereas the formula in your date example data table worked perfectly! So, I would also mark yours as a correct solution, even though it's not as elegant.

 

Thanks!,

DS

Article Labels

    There are no labels assigned to this post.