Hi all,

I'm having trouble converting string variables into date/time variables, and can only get "missing variables".
I can't figure it out, using the STATA 24 PDF "Working with dates and times"

My dates (variable name: result_date) are written as DD/MM/YYYY, (type (str8) and format (%9s))

I'm using the following code:

Code:
. gen iop_date=date(result_date,"DMY")
(1,116 missing values generated)
And can only get missing variables.
I have experimented with different date formats (day/month etc) and using the ## option for the Y, and have experimented by encoding the string date variables into long format, but can't get any other luck there.

Any advice would be so appreciated - sorry to ask such an elementary question.

Will