>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,
What would the resultant number be? Subtract one dat from another and you get the number of days between them, what would Date - Date - Date give you for an answer?