Does anyone know how to get from a date (imported from excel)
2/18/2012 3:56 to a stata date called 18feb2012?
thank you
Lars
2/18/2012 3:56 to a stata date called 18feb2012?
thank you
Lars
-
Login or Register
- Log in with
- You are not logged in. You can browse but not post. Login or Register by clicking 'Login or Register' at the top-right of this page. For more information on Statalist, see the FAQ.
-
-
under "help datetime", click on "sif-to-sif conversions" - the function you want is dofc (as shown in that part of the help file) -
ended up doing:
Code:gen new_date = dofc(date) format new_date %td
Comment
-
Note that "imported from Excel" means nothing here in itself. It covers everything from a string with that content to a formatted numeric date-time.Comment
Comment