So I have a heap of transactions each with [CalDate] - a date formatted as YYYY-MM-DD
I want to count the number of transactions the occurred in the last 7 days ; or be to precise, the last "loaded" 7 days.
My formula wasn't working, so I've tried to simplify it for testing.
Now I am just trying to create a set of the desired data, and return the earliest date.
I can't even get it to do that.
Broken down :
(This just produces NULL)
Solved! Go to Solution.
Your formula did work.
However, I was then curious as to why mine did not.
I started doing some comparisons and found this:
If I leave a space between the ">=" and the "$" of my nested expression, my formula fails completely.
If I remove the space, than it all works fine.
With hindsight, I guess it is parsing a space to the start of my date string !?
Is this something that I should have known ??
I don't recall seeing in documentation - but I can sometimes read a bit too fast for my own good !!
Again, hindsight is a wonderful thing.
Could be as you said a parsing error due to the space, just tried it here with the same result you got.
Normally i just type without spaces and this situation never occured to me, but its nice to know .