Remove time in datetime variable

[Torben Højmark]

I have a variable in an imported dataset from Excel in this type and format:
type: double
format: %tcnn/dd/ccYY_hh:MM

Example:
DATE
4/25/2019 10:50

I need a variable with only the date 4/25/2019 (not the just the format %td, but the exact date with out time decimals such that time is removed and the date value is int)

I've tried the following:
gen newvar = dofd(date) result= 1.87e+12
gen newvar = string(date, "%td") = "1.87e+12" // in order to use e.g. date, substring or split to create a new date var.

Can someone explain what the problem is?

Kind regards,
Torben

[Nick Cox]

You need dofc() not dofd().

[Torben Højmark]

Thank u Nick - it works.
Torben