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.
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