Skip to main content
InSource KnowledgeCenter

027941 - Excel query: Formula is too long


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



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