Hi, This problem might be a little harder than it appears.
I receive a few emails all suggesting that convert the Date field to character by calling format(date, "%m/%d/%Y") in one way or another. Well, this is not the solution I'm looking for and it doesn't work for me. All the date fields are generated with quotes around them, which will be treated by other software as string instead of date. Please note, the write.csv() function doesn't put quotes around date. All I need is to change the format behavior of Date without adding any quotes. So the output of CSV I'm looking for should be: "ticker","date","price" "IBM",12/03/2009,120 "IBM",12/04/2009,123 Not this: "ticker","date","price" "IBM","12/03/2009",120 "IBM","12/04/2009",123 Thanks for trying though. George From: [email protected] To: [email protected] Date: 12/28/2009 10:20 AM Subject: [R] How to change the default Date format for write.csv function? Sent by: [email protected] Hi, I have a data.frame containing a Date column. When using write.csv() function to generate a CSV file, I always get the Date column formatted as "YYYY-MM-DD". I would like to have it formatted as "MM/DD/YYYY", but could not find an easy way to do it. Here is the test code: d <- data.frame(ticker=c("IBM", "IBM"), date = as.Date(c("2009-12-03", "2009-12-04")), price=c(120.00, 123.00)) write.csv(d, file="C:/temp/test.csv", row.names=FALSE) The test.csv generated looks like this: "ticker","date","price" "IBM",2009-12-03,120 "IBM",2009-12-04,123 I would like to have the date fields in the CSV formatted as "MM/DD/YYYY". Is there any easy way to do this? Thanks in advance. George Zou The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses. Please refer to http://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. [[alternative HTML version deleted]] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses. Please refer to http://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. [[alternative HTML version deleted]] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
