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