Hi guys,

I do have an issue with my dates. My dates that I imported are in stata date and I tried to format them by using this code
Code:
format date %tdCCYYNNDD
but I get the error:
Code:
string %fmt required for string variables
r(120);
I tried to read me through helpdesk but I cannot manage to fix this issue. I tried to generate a new variable but it only produces missing values.
Code:
gen ndate=date(date,"DMY")


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str12 isin str5 date
"AU0000XINAW3" "32874"
"AU0000XINAW3" "32905"
"AU0000XINAW3" "32933"
"AU0000XINAW3" "32964"
"AU0000XINAW3" "32994"
"AU0000XINAW3" "33025"
"AU0000XINAW3" "33055"
"AU0000XINAW3" "33086"
"AU0000XINAW3" "33117"
"AU0000XINAW3" "33147"
"AU0000XINAW3" "33178"
"AU0000XINAW3" "33208"
"AU0000XINAW3" "33239"
"AU0000XINAW3" "33270"
"AU0000XINAW3" "33298"
"AU0000XINAW3" "33329"
"AU0000XINAW3" "33359"
"AU0000XINAW3" "33390"
"AU0000XINAW3" "33420"
"AU0000XINAW3" "33451"
"AU0000XINAW3" "33482"
"AU0000XINAW3" "33512"
"AU0000XINAW3" "33543"
"AU0000XINAW3" "33573"
"AU0000XINAW3" "33604"
"AU0000XINAW3" "33635"
"AU0000XINAW3" "33664"
"AU0000XINAW3" "33695"
"AU0000XINAW3" "33725"
"AU0000XINAW3" "33756"
"AU0000XINAW3" "33786"
"AU0000XINAW3" "33817"
"AU0000XINAW3" "33848"
"AU0000XINAW3" "33878"
"AU0000XINAW3" "33909"
"AU0000XINAW3" "33939"
"AU0000XINAW3" "33970"
"AU0000XINAW3" "34001"
"AU0000XINAW3" "34029"
"AU0000XINAW3" "34060"
"AU0000XINAW3" "34090"
"AU0000XINAW3" "34121"
"AU0000XINAW3" "34151"
"AU0000XINAW3" "34182"
"AU0000XINAW3" "34213"
"AU0000XINAW3" "34243"
"AU0000XINAW3" "34274"
"AU0000XINAW3" "34304"
"AU0000XINAW3" "34335"
"AU0000XINAW3" "34366"
"AU0000XINAW3" "34394"
"AU0000XINAW3" "34425"
"AU0000XINAW3" "34455"
"AU0000XINAW3" "34486"
"AU0000XINAW3" "34516"
"AU0000XINAW3" "34547"
"AU0000XINAW3" "34578"
"AU0000XINAW3" "34608"
"AU0000XINAW3" "34639"
"AU0000XINAW3" "34669"
"AU0000XINAW3" "34700"
"AU0000XINAW3" "34731"
"AU0000XINAW3" "34759"
"AU0000XINAW3" "34790"
"AU0000XINAW3" "34820"
"AU0000XINAW3" "34851"
"AU0000XINAW3" "34881"
"AU0000XINAW3" "34912"
"AU0000XINAW3" "34943"
"AU0000XINAW3" "34973"
"AU0000XINAW3" "35004"
"AU0000XINAW3" "35034"
"AU0000XINAW3" "35065"
"AU0000XINAW3" "35096"
"AU0000XINAW3" "35125"
"AU0000XINAW3" "35156"
"AU0000XINAW3" "35186"
"AU0000XINAW3" "35217"
"AU0000XINAW3" "35247"
"AU0000XINAW3" "35278"
"AU0000XINAW3" "35309"
"AU0000XINAW3" "35339"
"AU0000XINAW3" "35370"
"AU0000XINAW3" "35400"
"AU0000XINAW3" "35431"
"AU0000XINAW3" "35462"
"AU0000XINAW3" "35490"
"AU0000XINAW3" "35521"
"AU0000XINAW3" "35551"
"AU0000XINAW3" "35582"
"AU0000XINAW3" "35612"
"AU0000XINAW3" "35643"
"AU0000XINAW3" "35674"
"AU0000XINAW3" "35704"
"AU0000XINAW3" "35735"
"AU0000XINAW3" "35765"
"AU0000XINAW3" "35796"
"AU0000XINAW3" "35827"
"AU0000XINAW3" "35855"
"AU0000XINAW3" "35886"
end
thanks