Calculating a variance between dates - without + or -

[ejduran]

Hello,

I want to calculate the variance between two dates without caring whether its positive or negative. If there is a difference, I want to know the number of days between the two dates. I have a fixed start date in all cases and various end dates where I want to calculate a variance for.

For example:
May 10th is my start date. The record has one end date of May 15th. And another end date of May 5th. I will get +5 days for the first and -5 days for the second. I just want to know that it's 5 days, period.

The next record in my query will have a difference start date and different end dates, could be earlier, could be later.

Any help is appreciated.

Thanks,

 

[ejduran]

Oh, I figured it out. I put ABS() around my DateDiff calculation to get the absolute value.