Forum Discussion
shetzel
Sep 16, 2020Brass Contributor
Changing date format
I am getting my dates in this format, 2020-09-15 and would like to convert to 09/15/2020, is there a way to do that. I tried all options I have under custom format, but nothing worked. I have attache...
Riny_van_Eekelen
Sep 17, 2020Platinum Contributor
shetzel The dates were in fact texts and could thus not be reformatted. I used "text-to-column" to convert the texts to dates in a YMD format. Then, I custom formatted it to "mm/dd/yyyy". See attached.