Win 98 to Win XP conversion - date format problem in mail merge

[Ishbel Kargar]

Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my
mail-merge letters are doing strange things with date formats. For
instance, my reminder letter for lapsed subs carries the 'expiry' date as a
merge field from the database, and this previously was shown as dd/mm/yy (UK
format). Now it persists in showing as mm/dd/yy. I've gone to the Windows
Control Panel and made sure that my Regional settings show UK format, even
deleted the option for US format! On the database the date format inputs
correctly, but the mail merge doesn't!

I can't send letters out with this format, as we don't read dates this way
in UK. For instance, someone whose subs expired on 1st October 2003
(01/10/03 in UK format) would get a letter saying their subs expired on 10th
January 2003 (10/01/03 in US format!)

I've even tried amending the input mask for dates, but the mail merge letter
still shows 'expiry' as mm/dd/yy.

Can anyone help me sort this out?

Many thanks

Ishbel Kargar

[Phil Stanton]

Re: Win 98 to Win XP conversion - date format problem in mail merge

Waste of time asking for subs from someone who has expired :-(

"Ishbel Kargar" <ik@radmid.demo n.co.uk> wrote in message
news:bql6og$bg1 $1$8302bc10@new s.demon.co.uk.. .[color=blue]
> Since upgrading from old laptop (Windows 98) to new laptop (Windows XP),[/color]
my[color=blue]
> mail-merge letters are doing strange things with date formats. For
> instance, my reminder letter for lapsed subs carries the 'expiry' date as[/color]
a[color=blue]
> merge field from the database, and this previously was shown as dd/mm/yy[/color]
(UK[color=blue]
> format). Now it persists in showing as mm/dd/yy. I've gone to the[/color]
Windows[color=blue]
> Control Panel and made sure that my Regional settings show UK format, even
> deleted the option for US format! On the database the date format inputs
> correctly, but the mail merge doesn't!
>
> I can't send letters out with this format, as we don't read dates this way
> in UK. For instance, someone whose subs expired on 1st October 2003
> (01/10/03 in UK format) would get a letter saying their subs expired on[/color]
10th[color=blue]
> January 2003 (10/01/03 in US format!)
>
> I've even tried amending the input mask for dates, but the mail merge[/color]
letter[color=blue]
> still shows 'expiry' as mm/dd/yy.
>
> Can anyone help me sort this out?
>
> Many thanks
>
> Ishbel Kargar
>
>[/color]

[Ishbel Kargar]

Re: Win 98 to Win XP conversion - date format problem in mail merge

Dear Phil
[color=blue]
> Waste of time asking for subs from someone who has expired :-(
>[/color]

Thanks for your comment, quite logical I suppose, unless you know the people
I'm dealing with.

We are a small organisation and most of us know each other. Subs reminders
usually prompt an apologetic 'sorry I forgot to renew', together with a
cheque!

The letter I gave as an example was just one of several mail-merge letters,
and I really do need help with the date format problem.

So I still hope someone can help with the problem.

Regards to all

Ishbel

[Phil Stanton]

Re: Win 98 to Win XP conversion - date format problem in mail merge

Two thoughts

1) Is the Control Panel Regional and language Options set correctly
2) Might be worth trying to show the date Format as Medium Date in the
underlying query

Phil
"Ishbel Kargar" <ik@radmid.demo n.co.uk> wrote in message
news:bqlr6v$an1 $1$8300dec7@new s.demon.co.uk.. .[color=blue]
> Dear Phil
>[color=green]
> > Waste of time asking for subs from someone who has expired :-(
> >[/color]
>
> Thanks for your comment, quite logical I suppose, unless you know the[/color]
people[color=blue]
> I'm dealing with.
>
> We are a small organisation and most of us know each other. Subs[/color]
reminders[color=blue]
> usually prompt an apologetic 'sorry I forgot to renew', together with a
> cheque!
>
> The letter I gave as an example was just one of several mail-merge[/color]
letters,[color=blue]
> and I really do need help with the date format problem.
>
> So I still hope someone can help with the problem.
>
> Regards to all
>
> Ishbel
>
>
>[/color]

[Ishbel Kargar]

Re: Win 98 to Win XP conversion - date format problem in mail merge


"Phil Stanton" <discussion@sta ntonfamily.co.u k> wrote in message
news:3fcf0c9c$0 $98116$65c69314 @mercury.nildra m.net...[color=blue]
> Two thoughts
>
> 1) Is the Control Panel Regional and language Options set correctly[/color]

Yes, I've checked everything there, even deleted the option for USA format!
[color=blue]
> 2) Might be worth trying to show the date Format as Medium Date in the
> underlying query[/color]

Tried this, even converted the 'expiry' field in the main table to 'medium
date format', but it hasn't solved the problem. The Members Form also now
has 'medium date format', but the mail merge still produces the 'expiry'
date in mm/dd/yy - I'm puzzled! Not looking forward to altering all the
letters by hand!

Ishbel

[Phil Stanton]

Re: Win 98 to Win XP conversion - date format problem in mail merge

One last idea, Ishbel, after this I give up

Try

In your query for the mail merge try the date for your letter
DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")

I am assuming your table holding the ExpireyDate is defined as a Date/Time
and not text

Phil


"Ishbel Kargar" <ik@radmid.demo n.co.uk> wrote in message
news:bqoenl$sl$ 1$8302bc10@news .demon.co.uk...[color=blue]
>
> "Phil Stanton" <discussion@sta ntonfamily.co.u k> wrote in message
> news:3fcf0c9c$0 $98116$65c69314 @mercury.nildra m.net...[color=green]
> > Two thoughts
> >
> > 1) Is the Control Panel Regional and language Options set correctly[/color]
>
> Yes, I've checked everything there, even deleted the option for USA[/color]
format![color=blue]
>[color=green]
> > 2) Might be worth trying to show the date Format as Medium Date in[/color][/color]
the[color=blue][color=green]
> > underlying query[/color]
>
> Tried this, even converted the 'expiry' field in the main table to 'medium
> date format', but it hasn't solved the problem. The Members Form also now
> has 'medium date format', but the mail merge still produces the 'expiry'
> date in mm/dd/yy - I'm puzzled! Not looking forward to altering all the
> letters by hand!
>
> Ishbel
>
>[/color]

[Ishbel Kargar]

Re: Win 98 to Win XP conversion - date format problem in mail merge

"Phil Stanton" wrote:
[color=blue]
> One last idea, Ishbel, after this I give up
> Try
> In your query for the mail merge try the date for your letter
> DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")
>
> I am assuming your table holding the ExpireyDate is defined as a Date/Time
> and not text
>
> Phil[/color]

Dear Phil

I'm grateful for all your help, but I've finally solved the problem in a
completely different way.

I began to wonder if the problem was not with Access, but with Word, because
all the lists, labels, reports, etc. produced by Access showed the dates in
the UK format. And yes, all date fields were already set as Date/Time and
not as Text.

My new laptop has brought with it Word 2002, whereas all my reminder letters
were prepared using Word 2000. In spite of adjusting the date format in
Word 2002 to 'English UK format - dd/mm/yy' the problem persisted, so I took
the plunge, deleted Word 2002 (with some regret because I liked some of the
new facilities), and re-installed Word 2000 from my Office 200 Premium disk.

Hurray!! The date fields in the letters now show the dd/mm.yy format once
more and I can get on with my mailshot.

I did try your (one last try) suggestion before I took the drastic step
described above, and it was because that didn't work that I began to look at
the problem from a different angle, and realised that the culprit was Word
2002! My faith in Access has been restored!

Thanks again

Best wishes
Ishbel

[Phil Stanton]

Re: Win 98 to Win XP conversion - date format problem in mail merge

All good fun.

You would have thought Microsoft would have got that right. Or do you know
them better?????


Phil

"Ishbel Kargar" <ik@radmid.demo n.co.uk> wrote in message
news:bqvbc4$c25 $1$8300dec7@new s.demon.co.uk.. .[color=blue]
> "Phil Stanton" wrote:
>[color=green]
> > One last idea, Ishbel, after this I give up
> > Try
> > In your query for the mail merge try the date for your letter
> > DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")
> >
> > I am assuming your table holding the ExpireyDate is defined as a[/color][/color]
Date/Time[color=blue][color=green]
> > and not text
> >
> > Phil[/color]
>
> Dear Phil
>
> I'm grateful for all your help, but I've finally solved the problem in a
> completely different way.
>
> I began to wonder if the problem was not with Access, but with Word,[/color]
because[color=blue]
> all the lists, labels, reports, etc. produced by Access showed the dates[/color]
in[color=blue]
> the UK format. And yes, all date fields were already set as Date/Time and
> not as Text.
>
> My new laptop has brought with it Word 2002, whereas all my reminder[/color]
letters[color=blue]
> were prepared using Word 2000. In spite of adjusting the date format in
> Word 2002 to 'English UK format - dd/mm/yy' the problem persisted, so I[/color]
took[color=blue]
> the plunge, deleted Word 2002 (with some regret because I liked some of[/color]
the[color=blue]
> new facilities), and re-installed Word 2000 from my Office 200 Premium[/color]
disk.[color=blue]
>
> Hurray!! The date fields in the letters now show the dd/mm.yy format once
> more and I can get on with my mailshot.
>
> I did try your (one last try) suggestion before I took the drastic step
> described above, and it was because that didn't work that I began to look[/color]
at[color=blue]
> the problem from a different angle, and realised that the culprit was Word
> 2002! My faith in Access has been restored!
>
> Thanks again
>
> Best wishes
> Ishbel
>
>
>
>[/color]

[Ishbel Kargar]

Re: Win 98 to Win XP conversion - date format problem in mail merge

Dear Phil
[color=blue]
> All good fun.[/color]

I see your point, it does sound like good fun, though I was almost at my
wit's end, and didn't see it as funny as the days went by with no solution.

However, the fun side is definitely there, in the form of having solved yet
another problem, in my 'love-hate' relationship with my computer.
Especially as I was also trying to get help from my teenage grandson (who
knows 'everything there is to know' about computers?). It's given me quite
a buzz to be able to say that a 74 year old grandmother still has the edge!
[color=blue]
> You would have thought Microsoft would have got that right. Or do you know
> them better?????[/color]

I do now!

Thanks again

Regards
Ishbel