Date variable in Set Analysis

[danielact]

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.

[sunny_talwar]

What is the expression you are using right now?

[danielact]

=Count( {$<[Date Opened]={'=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate'}>} Distinct CaseNumber)

[sunny_talwar]

Difficult to comment unless we see it. Do you have a sample you can share?

[danielact]

Sorry, but no, I can't share the file.

[sunny_talwar]

Can you try this:

=Count( {$<[Date Opened]={"=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate"}>} Distinct CaseNumber)

[MarcoWedel]

Hi,

maybe helpful:

Dates in Set Analysis

regards

Marco