Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Pablo Bonilla <pablo.bonilla1234@gmail.com> |
To | statalist <statalist@hsphsun2.harvard.edu> |
Subject | st: format of S_DATE global |
Date | Thu, 16 Aug 2012 11:14:01 -0400 |
Dear Stata list, In the middle of a program I need to save in a csv file the exact date and time in which the program was used by somebody in my office. I use the following script in the middle of the program: tempname hh file open `hh' using "C:\data\time.csv ", write text append file write `hh' "$S_DATE, $S_TIME, `pais', `year', `survey' " _n file close `hh' When I open the CSV file in Excel it understands correctly those dates which its days are greater than 10 (e.g., 16 Aug 2012, 15 Apr 2012, 23 Jul 2012) but those which its days are smaller than 10 (e.g., 6 Aug 2012, 5 Apr 2012, 3 Jul 2012) Excel cannot read them as dates. I would like to know if I kind change the format of the S_DATE global, so it will display 08/16/2012 instead of 16 Aug 2012, So Excel can understand. Any other suggestion is more than welcome. Thanks -- ---- Pablo Bonilla * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/