Hi all,

I am having a problem doing some calculations and am not sure how to best get around it.

I am trying to calculate number of days as follows:

45-((date()-[date1])-[date2])

The problem I am having is that the first part (date()-[date1] is evaluating to a number and then trying to subrtract the date from it which gives me a operator/operand type mismatch(of course) but how to I get around it, I mean is there a way to subtract 3 dates and getting a number at the end. I have tried changing the parenthesis to have it evalueate all the date fields first but can not seem to get by the error.

Thanks for the help
James