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