Number between dates not showing

[jvitantonio]

Hi,

I have an application with actuals and budget. I have a table where I store my budget for different dates. The thing is the comparison for the dates is not working as the table for budget is showing always 0. Please check the application for further details. I appreciate your time and help.

[jvitantonio]

Anyone please? Any input will be appreciate it...

[chematos]

I had something like this before

sum({<REFERENCES.DATE_FROM={'>=$(vMinFullDate)<=$(vMaxFullDate)'} >} REFERENCES.VALUE)

Regards

[whiteline]

He has two fields REFERENCES.DATE_FROM and REFERENCES.DATE_TO.

And it seems that REFERENCES.DATE_TO selection is not working.

[jvitantonio]

That is correct whiteline. Also, when I remove the hour from the date it works but when I have the long date format 'DD/MM/YYYY hh:mm:ss' it doesn't...

[whiteline]

Moreover, I tried to compere the values (with hours) and it gives TRUE in a text box, while set analysis returns an empty set with the same statement.

[jvitantonio]

I think I know why... I'm comparing 4 dates that can be offset (can be or not included in the second dates). And in set analisys we are doing D1>= D2 "AND" D3<=D4. This condition is not always true. I change the data. Before I could have a range (1 record could be valid for Jan and Feb). Now I place 1 record for Jan and 1 for Feb so I don't have problem comparing the dates. It's a bit hard to explain