Date Format change

[frustrated_macro]

So i use date format mm/dd/yyy but the report i am exporting us using dd/mm/yyyy + the time, so it comes out like this

10/02/2025 16:21:21 +0000

that record is for Feb 10 not Oct 2

i dropped the date with the Text to Coulmnm fixed width (although im sure there is a much better way to do it)
but how can i format the date to understand that thats not Oct 2?

 

[RoryA]

The last step of the text to columns wizard allows you to specify that a field is a date and what format it is in:

 

[frustrated_macro]

The last step of the text to columns wizard allows you to specify that a field is a date and what format it is in:
View attachment 122226

you are an angel sent from the gods.
i literally never pay attention to that screen

thank you