Dobbin69
5 posts
msg #149736
- Ignore Dobbin69 |
12/2/2019 4:55:21 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
|
xarlor
587 posts
msg #149748
- Ignore xarlor |
12/2/2019 11:33:35 AM
Reading the SF manual, as best as I can tell, "within the last" applies only to the following statements:
"crossed above/below"
"gained/lost more than"
"reached a new high/low"
How to fix your statement? Two ways:
|
nibor100
1,046 posts
msg #149755
- Ignore nibor100 |
12/2/2019 1:04:57 PM
Oops! looks like you already have a reply,
Ed S.
|
Dobbin69
5 posts
msg #149771
- Ignore Dobbin69 |
12/3/2019 7:28:23 AM
Xarlor, Ed S
Cheers!
That makes sense now, I was pulling (what's left of) my hair out...
Much obliged!
|