Format date from MM/dd/yyyy to MM/dd

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DeepThought - 18 Jul 2007 15:54 GMT

The field in my Access database is Birth.

The data in the field appears as ex. 10/2/1964 but when printed on a report
it should appear as 10/2.

I've tried the following:
{Mergefield Birth \@ "MM/dd"}
{Mergefield "Birth" \@ "MM/dd"}
{Mergefield Birth \* "MM/dd"}
{Mergefield "Birth" \* "MM/dd"}

but the data returned is 10/2/1964.

Any help?

I need to have this resolved by THU close of business.

Thanks in advance.

Reply to this Message

Peter Jamieson - 18 Jul 2007 17:20 GMT

Can you find out what data type the field has in the Access database? Is it
a "date", or is it actually set up to be "text"? Which version of
Word/Access, and how are you oonnecing to the Word database? Are you in a
position to create queries in the database or use VBA in Word?

(FWIW I would expect your first two examples to work).

Peter Jamieson

> The field in my Access database is Birth.
>
[quoted text clipped - 15 lines]
>
> Thanks in advance.

Reply to this Message

DeepThought - 18 Jul 2007 17:40 GMT

Data Type: text

Word 2003
Access 2003

Not certain of connection type, but this is a database I just created for
testing (a single table) before I handed it off to the lead programmer--the
queries were automatically written by virtue of using the Mail Merge utility,
as I understand it.

> Can you find out what data type the field has in the Access database? Is it
> a "date", or is it actually set up to be "text"? Which version of
[quoted text clipped - 23 lines]
> >
> > Thanks in advance.

Reply to this Message

DeepThought - 18 Jul 2007 20:14 GMT

Actually, the lead programmer and I got the first example to run properly!

All's well that ends well!

> The field in my Access database is Birth.
>
[quoted text clipped - 14 lines]
>
> Thanks in advance.

Reply to this Message

Peter Jamieson - 19 Jul 2007 09:25 GMT

Thnak goodness for that! - I checked and could not create an example in
Access that would not work even with a text field.

Peter Jamieson

> Actually, the lead programmer and I got the first example to run properly!
>
[quoted text clipped - 19 lines]
>>
>> Thanks in advance.

Reply to this Message