Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a text box which uses set analysis containing a date variable. The date is changed using a calendar object. It calculates correctly at first, but when I change the date, it doesn't update the result in the text box. If I do something (such as change to WebView and back, or go into the formula and add a space to it), it will update to the correct value. It appears it just isn't recalculating as it should.
Any idea if there's a way to fix this glitch? I really don't want to have to use an If statement for it.
What is the expression you are using right now?
=Count( {$<[Date Opened]={'=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate'}>} Distinct CaseNumber)
Difficult to comment unless we see it. Do you have a sample you can share?
Sorry, but no, I can't share the file.
Can you try this:
=Count( {$<[Date Opened]={"=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate"}>} Distinct CaseNumber)