Hello!

I am currently trying to create a "date" variable from my current variable named "Date".

I have tried the following code:

Code:
gen date = date(Date, "DMY")
but this code only creates a "type mismatch" for me.

Did I format the current date variable incorrectly? I don't understand why the date function doesn't accept the code.




Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int Date str15 ISIN double RID
9132 "IT0000060886" .n
9133 "IT0000060886" .n
9134 "IT0000060886" .n
9135 "IT0000060886" .n
9138 "IT0000060886" .n
9139 "IT0000060886" .n
9140 "IT0000060886" .n
9141 "IT0000060886" .n
9142 "IT0000060886" .n
9145 "IT0000060886" .n
9146 "IT0000060886" .n
9147 "IT0000060886" .n
9148 "IT0000060886" .n
9149 "IT0000060886" .n
9152 "IT0000060886" .n
9153 "IT0000060886" .n
9154 "IT0000060886" .n
9155 "IT0000060886" .n
9156 "IT0000060886" .n
9159 "IT0000060886" .n
9160 "IT0000060886" .n
9161 "IT0000060886" .n
9162 "IT0000060886" .n
9163 "IT0000060886" .n
9166 "IT0000060886" .n
9167 "IT0000060886" .n
9168 "IT0000060886" .n
9169 "IT0000060886" .n
9170 "IT0000060886" .n
9173 "IT0000060886" .n
9174 "IT0000060886" .n
9175 "IT0000060886" .n
9176 "IT0000060886" .n
9177 "IT0000060886" .n
9180 "IT0000060886" .n
9181 "IT0000060886" .n
9182 "IT0000060886" .n
9183 "IT0000060886" .n
9184 "IT0000060886" .n
9187 "IT0000060886" .n
9188 "IT0000060886" .n
9189 "IT0000060886" .n
9190 "IT0000060886" .n
9191 "IT0000060886" .n
9194 "IT0000060886" .n
9195 "IT0000060886" .n
9196 "IT0000060886" .n
9197 "IT0000060886" .n
9198 "IT0000060886" .n
9201 "IT0000060886" .n
9202 "IT0000060886" .n
9203 "IT0000060886" .n
9204 "IT0000060886" .n
9205 "IT0000060886" .n
9208 "IT0000060886" .n
9209 "IT0000060886" .n
9210 "IT0000060886" .n
9211 "IT0000060886" .n
9212 "IT0000060886" .n
9215 "IT0000060886" .n
9216 "IT0000060886" .n
9217 "IT0000060886" .n
9218 "IT0000060886" .n
9219 "IT0000060886" .n
9222 "IT0000060886" .n
9223 "IT0000060886" .n
9224 "IT0000060886" .n
9225 "IT0000060886" .n
9226 "IT0000060886" .n
9229 "IT0000060886" .n
9230 "IT0000060886" .n
9231 "IT0000060886" .n
9232 "IT0000060886" .n
9233 "IT0000060886" .n
9236 "IT0000060886" .n
9237 "IT0000060886" .n
9238 "IT0000060886" .n
9239 "IT0000060886" .n
9240 "IT0000060886" .n
9243 "IT0000060886" .n
9244 "IT0000060886" .n
9245 "IT0000060886" .n
9246 "IT0000060886" .n
9247 "IT0000060886" .n
9250 "IT0000060886" .n
9251 "IT0000060886" .n
9252 "IT0000060886" .n
9253 "IT0000060886" .n
9254 "IT0000060886" .n
9257 "IT0000060886" .n
9258 "IT0000060886" .n
9259 "IT0000060886" .n
9260 "IT0000060886" .n
9261 "IT0000060886" .n
9264 "IT0000060886" .n
9265 "IT0000060886" .n
9266 "IT0000060886" .n
9267 "IT0000060886" .n
9268 "IT0000060886" .n
9271 "IT0000060886" .n
end
format %tdnn/dd/CCYY Date