MS SQL Server 2005 Express Date Range Found Set problem

[swillette]

I have a problem with a date find in a MS SQL related table. The user types in a begin and end date into two global fields, where I have a script put the dates into global variables. My script enters find mode and puts the two variables in the SQL date field for the search. Here is that part of the script.

Set Field [TimeEntry::TEDate; $$BeginDate & “…” & $$EndDate]

The script seems to work find bring up all found set records including the TEDate (s) for the range.

The problem is that I get more records in my FileMaker layout then if I do the search using a SQL query directly in MS SQL Server Express 2005.

Is the problem because of SQL’s date format? YYYY/mm/dd

There is also a Time in this field, but all of the fields have 12:00:00 AM in them.

I am using FileMaker 12 Advanced. Should I use the Execute SQL function to do this search in my script? Any help writing would be great.

[swillette]

I had the wrong year in my find. I would like to delete this post but I don't see a delete button.