Dear statalist,
I am trying to change the date format of one my date variable. It has the followinf format MM/DD/YYYY and I would like to take the format DD/MM/YYYY

Its the variable DATE in my dataset hereafter



[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str13 company_id long DATE int set long date int set2 float(day month year date_proper date_properrrr)
"FR0000121261" 18065 1 18065 1 17 6 2009 18065 .
"FR0000120271" 17966 2 17966 2 10 3 2009 17966 18173
"FR0000120271" 18078 3 18078 3 30 6 2009 18078 .
"FR0000031122" 17941 4 17941 4 13 2 2009 17941 .
"FR0000031122" 18002 5 18002 5 15 4 2009 18002 .
"FR0000031122" 18144 6 18144 6 4 9 2009 18144 17996
"FR0000120073" 18188 7 18188 7 18 10 2009 18188 .
"FR0010313833" 18192 8 18192 8 22 10 2009 18192 .
"FR0000130007" 17939 9 17939 9 11 2 2009 17939 18203
"FR0000071946" 18188 10 18188 10 18 10 2009 18188 .
"AT0000837307." 18043 11 18043 11 26 5 2009 18043 .
"FR0000034639" 18066 12 18066 12 18 6 2009 18066 .
"LU0323134006" 17994 13 17994 13 7 4 2009 17994 18082
"FR0000051732" 17946 14 17946 14 18 2 2009 17946 .
"FR0000035164" 17989 15 17989 15 2 4 2009 17989 17932
"FR0000121568" 18074 16 18074 16 26 6 2009 18074 .
"FR0000131757" 18114 17 18114 17 5 8 2009 18114 18025
"FR0000121147" 17933 18 17933 18 5 2 2009 17933 18019
"FR0004076891" 17962 19 17962 19 6 3 2009 17962 18051
"FR0000133308" 17960 20 17960 20 4 3 2009 17960 17990
"FR0000063935" 18136 21 18136 21 27 8 2009 18136 .
"US37045V1008" 18144 22 18144 22 4 9 2009 18144 17996
"FR0004061513" 17920 23 17920 23 23 1 2009 17920 .
"FR0000121485" 17939 24 17939 24 11 2 2009 17939 18203
"FR0000052680" 17933 25 17933 25 5 2 2009 17933 18019
"FR0000120321" 17945 26 17945 26 17 2 2009 17945 .
"FR0011476928" 17946 27 17946 27 18 2 2009 17946 .
"FR0000121485" 18175 28 18175 28 5 10 2009 18175 18027
"FR0000038606" 17992 29 17992 29 5 4 2009 17992 18021
"FR0000032278" 18156 30 18156 30 16 9 2009 18156 .
"FR0000121014" 17934 31 17934 31 6 2 2009 17934 18050
"FR0000064941" 18063 32 18063 32 15 6 2009 18063 .




Thanks a lot