Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word says date is invalid in the filter value in mail merge
I am set up to enter dates as 11-Feb-09 in regional preferences. I enter
dates in Excel as dates, formatted as dd-MMM-yy. I want to do a mail merge where I select only rows where Send Status letter is equal to a given date in the filter. When I try to enter the filter date in the dialog, I get date is invalid. What is the correct way (format) to enter a date in this field? Word 2007, Excel 2007. Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word says date is invalid in the filter value in mail merge
As far as I know, in Word 2007 using the default OLE DB connection
method, you can specify the date in US MM/DD/YYYY format or YYYY-MM-DD format. However, it would not surprise me if this did not always work... Peter Jamieson http://tips.pjmsn.me.uk Grey Guru wrote: I am set up to enter dates as 11-Feb-09 in regional preferences. I enter dates in Excel as dates, formatted as dd-MMM-yy. I want to do a mail merge where I select only rows where Send Status letter is equal to a given date in the filter. When I try to enter the filter date in the dialog, I get date is invalid. What is the correct way (format) to enter a date in this field? Word 2007, Excel 2007. Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter merge data by Date | Mailmerge | |||
Filter Merge Data by Date Range | Mailmerge | |||
Mail merge filter/sort problem in Word 2003 | Mailmerge | |||
word 2003 mail merge filter problems | Mailmerge | |||
How do I filter a Dbase date field in a word mail merge documnet? | Mailmerge |