Date field?

[Mr Ashim]

I have linked a word doc to a table within my DB, but when info merged the date field keeps showing time info as well e.g. (10/10/2003 00:00:00). Can any one help all i want is the date format. Ive tried changing input masks and formating at table level but seem to be getting nowhere.

 

[ghudson]

Format the field in the table as MM/DD/YYYY. You will have to do this again in any form, query, report that you reference that date field. That format is for display purposes only since the actual value for each record in that field will still contain the date and empty [00:00:00] time as well.

 

[Mr Ashim]

Format the field in the table as MM/DD/YYYY. You will have to do this again in any form, query, report that you reference that date field. That format is for display purposes only since the actual value for each record in that field will still contain the date and empty [00:00:00] time as well.

Thanks will try to sort this out after the easter weekend. Your advice is much appreciated.

 

[Mr Ashim]

Format the field in the table as MM/DD/YYYY. You will have to do this again in any form, query, report that you reference that date field. That format is for display purposes only since the actual value for each record in that field will still contain the date and empty [00:00:00] time as well.

Back from my holiday and tried the above. Unfortunately I didn’t have a lot of luck formatting at table level ect. However I formatted the actual document by highlighting the date field, right click and all that and that sorted the problem. Thanks again for your help.

 

[Pat Hartman]

Rather than exporting/importing a table, create a query that formats the date as you want to see it. Then import/export the query.