Filter Merge Data by Date Range

[Stuart Troy]

Hi Guys,

I'm merging with an SQL table, which includes a date column.
And I need to merge the records for a specific day only.

The date column is formatted as '2007-12-31' (yyyy-mm-dd) and includes a
time stamp 00:00:00.

But when I use "Filter & Sort" in Word, I cannot get it to filter by the
date at all. No matter what varations of operators & values I try, it won't
filter the results.

I know I could create a View in SQL, but I'd like to find a Word based
solution.

Thanks for your input.
Kind regards
Stuart
Sydney, AUSTRALIA

 

[Peter Jamieson]

The trouble is that Word tries to generate the wrong syntax SQL code, then
gets confused (as far as I know).

Also AFIK, the only approach to a solution other than using a view is to
issue your own SQL in Word VBA, e.g.

ActiveDocument.MailMerge.OpenDataSource _
Name:="the pathname of the .odc file you are using to connect", _
SQLStatement:="SELECT * FROM [mytable] WHERE [mydate] = '2007-12-31'

Peter Jamieson

 

[Stuart Troy]

Thanks Peter,
I used a similiar solution, using the DATABASE field with an SQL query.
It works nicely.
Thanks again.
Stuart
Sydney, AUSTRALIA