brianmfear / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 1 forks source link

Cannot view records that were modified on day of querying #48

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Go to 'SForce Table Query Wizard' in the sforce Connector Add-In
2. Select 'Account' as the 'Table to Query'
3. Leave filter blank (want all account records)

What is the expected output? 
All accounts

What do you see instead?
All records that have been modified today or previously (so all records)

What version of the product are you using? 
The latest one I think... SForce_Office_Toolkit_MSI zipfile and 
sforce_connect.xla Sorry, I can't find the dates.

On what operating system?  
Microsoft Windows XP Professional, Version 2002

With what Salesforce.com edition?
Enterprise Edition

Please provide any additional information below.

If possible, please enable a 'less than or equal to' operator, this would solve 
the problem. Is it possible to do a logic filter using two queries???

At first, I could only view the records that had been modified in the last 7 
days. Then I started to filter by 'System Modstamp less than 10/31/11' (today's 
date) and I did get the vast majority of my records but of course not those 
that happened to be modified today. When I tried to filter by 'System Modstamp 
less than 11/01/11' (tomorrow's date) I could only see those records that had 
been modified in the last week. 

I also tried to filter by 'Last Modified Date less than 10/31/11' and 'Account 
name not equal to ' zero, but to no avail. 

Original issue reported on code.google.com by slru...@gmail.com on 31 Oct 2011 at 9:49