Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have dates formatted in MMM-YY. Why won't the following set analysis work? It gets the results, but appears to be calculating as < not <= (doesn't include maximum month).
{<[Encounter Month/Year]={"<=$(=max([Encounter Month/Year]))"}>}
The only way I have figured out to get the correct value is to use < and add 30 days
{<[Encounter Month/Year]={"<$(=DATE(max([Encounter Month/Year])+30,'MMM-YY'))"}>}
However, strangely enough, >= appears to work.
Thanks!
Strange thing is, Copy of app reloaded in last version works fine but fails(<= works like <) when reloaded in new version.
Have you noticed the same bug that was mentioned in this thread? Are you on Sep 2018 version?
@kmstephenson wrote:Have you noticed the same bug that was mentioned in this thread? Are you on Sep 2018 version?
Is this question for me? If it is, I don't have Sept 2018 version, but I can download it and check. But again, without a sample... updating to Sept2018 won't really matter.
But you don't have to need confirmation from me. If both of you are having the same issue, then it might very well be a bug and you can either downgrade to an older version or wait for a fix to come out and use an updated version of the expression you proposed.
Best,
Sunny