You cannot substract a date from a number. Since the first operation (date()-date1) results in a number...
Vlad
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement