DateDiff Syntax Help

[burrina]

Here is my syntax,it works but when there is no difference, I need it to show 0

VacDays: (DateDiff("d",[VacationDteFrom],[VacationDteTo]))

 

[Ranman256]

if the days are the same you WILL get zero.
Null wont give an answer.

 

[burrina]

No, the posted code above does not return anything! hence the post!

 

[vbaInet]

Remember your Nz() burrina?

 

[burrina]

This syntax: Results in #Error

VacDays: Nz((DateDiff("d",[VacationDteFrom],[VacationDteTo])))

 

[vbaInet]

This:

VacDays: Nz[COLOR="red"]([/COLOR]DateDiff("d",[VacationDteFrom],[VacationDteTo])[COLOR="Red"], 0)[/COLOR]

Sorry Ranman256, I thought you were offline!

 

[burrina]

Was having a Code moment.

 

[vbaInet]

You certainly were because I know that you know this stuff

 

[burrina]

True, but it sucks to get old. Plus with my condition it puts a whooping on my thinking.

Poor,Pitiful Me ! Guess I will go off and cry in my Beer !

 

[vbaInet]

or whiskey