3 replies
by misscrf
I have had date issues myself in Access. Mine was that the data came with the time, which was stupid because they were all 00:00:00. Anyway, it had to come in as text, and I built a formula in the queries of my reports to format the date as I wanted it. This is one option for you.
For a report you have, go to the query and make a formula like so:
fieldnamefornamewithformula: Mid([fieldname],5,2) & "/" & Right([fieldname],2) & "/" & Left([fieldname],4)
It will show like: 09/15/2004
Another option is to tried the med date. It uses this input mask:
00->L
by alpha48
Sometimes changing formats midstream can cause problems with the records already in the database. So you may want to make a copy of your DB and try this. Go back to the table with the date field in design view, click on the imput/format shown and backspace thru the time digits. Save. A warning about the change should appear, but is only a copy so ignore it. Run the report. If the time still appears, go to the design tab for report or form you are printing and go to the date field, right click and go into properties. Go through the tabs at the top till you find the date [All Data?]. If it too shows the time characters back space through those also. Run the report or form. If all goes well, you can repeat the steps in the real version.
Regards.
by chavdaraju
when u copy new data your new data format must be same. if you r using a query to copy the data, change the format using format function with your new data.
The other way is, after copying new data you can update it using query.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending