Forum Discussion
Post ProdigyDateDiff with a BLANK value
Post ProdigyIt looks like my explenation made it harder for you :)
the Table 'Damage' en the Table 'Complaints' have NO relationships between eachother and there is no need to. The only relationship they both have is with the table 'Date'.
Fore example:
A complaint is registered in our system on the 25th of July and is solved on the 27th of July, that means it took us 3 days (Tuesday till Thursday) to resolve that complain, value should be 3 workingdays.
A complaint is registered in our system on the 25th of July and is solved on the 1st of August, that means it took us 8 days (Tuesday till Tuesday) to resolve that complain, but in those 8 days there is a Saterday and a Sunday, so the value should be 6 workingdays.
Community Champion
i get that, so are you saying there is only one complaint per day? and one damage per day? because how does it know which date links a complaint to a damage?