 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Exporting the Date without the time
I am trying to reformat a date/time field to export it without the time. Article 291245 gives a suggestion (Method 1), but I can not figure out how to implement the suggestion. Can not figure out how to do a new calculated field with the suggested format. Any help would be greatly appreciated. Thanks in advance. - John You can use the format, to return only the date without the time CDate(Format(DateField,"dd/mm/yyyy"))  SignatureThe next line is only relevant to Microsoft''s web-based interface users. If I answered your question, please mark it as an answer. It''s useful to know that my answer was helpful HTH, good luck > I am trying to reformat a date/time field to export it without the time. > Article 291245 gives a suggestion (Method 1), but I can not figure out how to > implement the suggestion. Can not figure out how to do a new calculated > field with the suggested format. > > Any help would be greatly appreciated. Thanks in advance. - John >I am trying to reformat a date/time field to export it without the time. >Article 291245 gives a suggestion (Method 1), but I can not figure out how to >implement the suggestion. Can not figure out how to do a new calculated >field with the suggested format. Did you forget to create a query to use for the export? Once you have the query open in design view, replace your datetime field with something like: MyDate: Format([datetimefield], "mm/dd/yyyy") SignatureMarsh MVP [MS Access] Marshall, thanks. Not exactly sure what I was doing wrong, but this did the trick. - John > >I am trying to reformat a date/time field to export it without the time. > >Article 291245 gives a suggestion (Method 1), but I can not figure out how to [quoted text clipped - 7 lines] > > MyDate: Format([datetimefield], "mm/dd/yyyy") Not sure how to mark this as the answer. Nothing comes up in the message pane. > >I am trying to reformat a date/time field to export it without the time. > >Article 291245 gives a suggestion (Method 1), but I can not figure out how to [quoted text clipped - 7 lines] > > MyDate: Format([datetimefield], "mm/dd/yyyy") It's Ok, you did mark it as an answer, you can see by the green mark > Not sure how to mark this as the answer. Nothing comes up in the message pane. > [quoted text clipped - 9 lines] > > > > MyDate: Format([datetimefield], "mm/dd/yyyy") I appreciate the thought John, but don't go out of your way marking these things. They're just used to tell other folks with a similar question that the suggested approach worked. There is (currently?) no personal benefit to anyone and the vast majority of people that use a real news reader program instead of the web interface will never see it anyway. A simple post with "Thanks, that worked" is sufficient and reaches a far wider audience SignatureMarsh MVP [MS Access] >Not sure how to mark this as the answer. Nothing comes up in the message pane. > [quoted text clipped - 9 lines] >> >> MyDate: Format([datetimefield], "mm/dd/yyyy") |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.