473,373 Members | 1,686 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,373 software developers and data experts.

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

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
Nov 12 '05 #1
8 2225
Waste of time asking for subs from someone who has expired :-(

"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk...
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

Nov 12 '05 #2
Dear Phil
Waste of time asking for subs from someone who has expired :-(


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

Nov 12 '05 #3
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.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk...
Dear Phil
Waste of time asking for subs from someone who has expired :-(

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

Nov 12 '05 #4

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.net ...
Two thoughts

1) Is the Control Panel Regional and language Options set correctly
Yes, I've checked everything there, even deleted the option for USA format!
2) Might be worth trying to show the date Format as Medium Date in the
underlying query


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
Nov 12 '05 #5
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.demon.co.uk> wrote in message
news:bq******************@news.demon.co.uk...

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.net ...
Two thoughts

1) Is the Control Panel Regional and language Options set correctly
Yes, I've checked everything there, even deleted the option for USA

format!
2) Might be worth trying to show the date Format as Medium Date in the underlying query


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

Nov 12 '05 #6
"Phil Stanton" wrote:
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


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


Nov 12 '05 #7
All good fun.

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

"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk...
"Phil Stanton" wrote:
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
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

Nov 12 '05 #8
Dear Phil
All good fun.
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!
You would have thought Microsoft would have got that right. Or do you know
them better?????


I do now!

Thanks again

Regards
Ishbel

Nov 12 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: praba kar | last post by:
Dear All, I have doubt regarding date string to time conversion function. In Python I cannot find flexible date string conversion function like php strtotime. I try to use following type...
2
by: William Wisnieski | last post by:
Hi Everyone, Access 2000 I have some code behind a button that performs a word merge with a query data source. The merge works fine. But what I'd like to do somehow is after the merge is...
7
by: Andy Davis | last post by:
I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which...
3
by: Reb | last post by:
Hi, How do i convert this "Sun Jun 29 00:00:00 UTC 0800 2003" to the normal date format (mm/dd/yyyy). Thanks Reb
2
by: Sueffel | last post by:
Having a small problem figuring out how to convert the following structures to VB: private struct RECT { public int left; public int top; public int right; public int bottom;
10
by: Arno R | last post by:
Hi all, I have a database that I need to use in different versions of Access. This is A97 in most places and A2k in a few other locations. (I develop in A97 and convert the db to A2k for these...
1
by: scott | last post by:
Hi Everyone, I don't know if this is the correct forum but I thought i'd ask. I have an access DB with a function to automatically safe a table with fields i'm mail merging into MS Word. Word...
5
by: johnvon | last post by:
I have a mail merge that runs flawlessly in Access 2000. In 2003 I keep getting dialog boxes that I can't figure out how to supress. Several of them are telling me that Admin (me!) has the database...
1
by: beechclose | last post by:
I have an form in Access which runs a make-table query and then mail merges the contents to Word. One of the merged fields is a date - in Access the date appears in 'UK' format correctly but when...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.