Dobbin69 5 posts msg #149744 - Ignore Dobbin69 | 
12/2/2019 10:00:50 AM
  Hi all, 
 
 I'm new to the forum but have just subscribed to SF after trialling for a few weeks. It's very useful. However one thing I have a problem with is the "within" phrase and I'd really appreciate feedback or help with this. I could well be approaching things wrongly but when I type "CCI(20) was below -200 within the last 6 days" on todays date it returns 3 matches (from memory) but when you replace the 6 days with 3 days as a test it returns a lot more entries. This is obviously not acting as I want it to, as with lesser number of days the results should be the same as or lower than 6 days not more! 
 
 Obviously this is not the full extent of my search query as I look for more than just the CCI but when this one line shows incorrect results, I can't trust using the within phrase at all. I have tried getting around this by saying for example "CCI(20) was below -200 6 days ago" which appears fine but what if there was one 5 days ago, or 4 etc etc, and I really want to be able to use the "within" phrase. 
 
 Any ideas on a workaround or is it just that I am inputting things the wrong way round etc? 
 
 Many thanks for taking the time to read/reply to this in advance. 
 
 Cheers! 
 
 Scott
 
 Copied to here from general discussion where it probably shouldn't have been posted.. 
 
  |