Date - Statalist

Search in titles only
Search in General only Advanced Search

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.

X

Sr Flavio

Join Date: Jun 2021
Posts: 26

#1

Date

13 Nov 2021, 19:15

Hi, How do I get to date in dd/mm/yyyy format?
For example: 03/01/2011
Thanks!

Code:

* Example generated by -dataex-. For more info, type help dataex
clear
input str19 date
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
"2011-01-03 00:00:00"
end

Tags: None

Clyde Schechter

Join Date: Apr 2014

Posts: 29998
#2

13 Nov 2021, 19:33

Code:

gen wanted = dofc(clock(date, "YMDhms")) format wanted %tdDD/NN/CCYY

Note: I am assuming that the 01-03 part of your data refers to 3 January, not 1 March. If that's wrong, then it should be "YDMhms" in the second argument of clock().
Comment
Sr Flavio

Join Date: Jun 2021

Posts: 26
#3

14 Nov 2021, 05:48

Thank you!
Comment

Previous Next

Working...

X