Skip to main content
InSource KnowledgeCenter

027941 - Excel query: Formula is too long

Problem

The customer edited his AF query manually, and now Excel is complaining that his AF query is too long. How can it be shortened?

Product Version: 9.2

OS: Win 2003

OS_SP: SP2

Solution

Customer sent me his query but not much could be done. A few lines like "And wwVersion = 'Latest' and "wwRowCount=0" are unnessesary. Also changed it from DateTime >= StartDate and DateTime>= EndDate to DateTime between StartDate and EndDate. There wasn't much that could be shortened, but this should be enough to get it shorter then Excel's limit.

Close Date: 2009-06-19 16:24:20