| 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..
 
 
 |