To a standard ascci file. Access has a time attached to each date format, it only displays the fomat that you choose, but the date remains and is exported.
I don't have a time field, and I don't want any time to export. I need to export in text. The date/time fild automatically stores both the date and the time, even on the short format. Even though we can't see the time, it saves the midnight since it has no data. How can I jsut get rid of the...
No, unfortunately, I have a required format to deliver, so I can't have them reformat on the other end. Do you have any idea what script could be used to strip the time from the date/time field?
I find it impossible to export a date without having a time attached. How do I wipe out the date on export? This is a function that I need for exporting repetetively, for I need to export certian data entry time periods on an ongoing basis.
Thanks
I have built a database with Access 97. I need to export certain fields, not all. I have created an export query and no matter what I do, when I export a date field, I get the date and the time. I have used specific date formating for the export, and it still carries the time with it.
Can...
If I do that, it still exports the time with the date when exporting to text. It does not do it to rtf. I need to be able to strip away the unseen, but present time on export.
Thanks for all of the ideas
Thanks again. I am still having a problem. It states that the code that you gave me to strip the time from the date creates a syntex error......
The exact code, with a field label of "birthdate" should read???????
Can someone please tell me how I can export dates without times in Access 97? I have tried the short format, but I still get the time. I am sure that I am missing something simple, but am really stuck.
Using the mm/dd/yyyy format also results in the time appearing in the export. I do not have any data fields relating to time in my data base. Is the input mask an issue?
Thanks. I do not have a time field and do not collect times at all. The format for the short date does not include times. Any ideas why it is appearing in the export?
Hi everyone. I have been struggling for 2 weeks now. I have Access 97. I have a number of date fields and have them formatted as short date. Whenever I export to text, I get the short date as well as a time. I do not want time which is why I chose the short format. I have reinstalled...
I am stuck and need some help please. I am using Access 97. I have chosen the short date format, but on each export, it exports the date and a time. How do I get rid of the time???? I have tried everything and have reinstalled Access 3 times now.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.