Substracting dates

[Bikeman17]

Hi

I would like to substrack two dates and get the result in number. Something like 04/01/2006 - 01/01/2006 = 4

Thanks

[Raybaudi]

Hi

the two dates are into two date fields ?

If so, the calc is: date2 - date1 + 1

or, if you don't know wich is the greatest:

Abs(date2 - date1) + 1

[Bikeman17]

I try to substract the current day which is a calc and a date field. I end up with a weird result.

[Raybaudi]

Your current day calc ( = Get ( CurrentDate ) ) must be UNSTORED

[Matt Klein]

Hi

I would like to substrack two dates and get the result in number. Something like 04/01/2006 - 01/01/2006 = 4

Thanks

Well, you can create a calculation field whose result is a Number and basically use the equation you wrote. Assuming the dates are in two fields it would be as simple as:

Date2 - Date1

However, this will return the number of days not the number of months as it appears that you are looking for. You could then try:

Truncate((date2 - date1)/30,0)

This basically takes the number of days between the two dates and divides it by an estimated number of days per month. Then, the Truncate function just drops the numbers to the right of the decimel. You could leave the Truncate function of if you want the exact number of months.

It should be noted though that using the above calculation using the two dates that you used in your post would not return 4. It would return 3.

[Bikeman17]

it is...

[Raybaudi]

I think that Bikerman17 is using the format:

DDMMYYYY (international)

Isn't so, Bikerman ?

[Matt Klein]

I think that Bikerman17 is using the format:

DDMMYYYY (international)

Isn't so, Bikerman ?

That would explain it. Sorry. I was looking at it from a U.S. perspective. Either way though, you would have add 1 to the result like Daniele did in an earlier post.

[Raybaudi]

I try to substract the current day which is a calc and a date field. I end up with a weird result.

Please, give us an example of those "weird result"

[Bikeman17]

Yes I am using the internationnal format but it doesn't matter. I got -86.

[Raybaudi]

Please, check your fields definitions...

date1 must be a date

date2 must be a calc (result date) = GetCurrentDate

Difference must be a calculation (result number)

[Bikeman17]

Perhaps I am missing something, attach a sample to your next reply. I'd like to see that in detail.

[Raybaudi]

Here it is !

P.S. I have added some "case" statement, so if the date is empty, the calc don't evaluate.

DateDifference.zip

[Bikeman17]

Basically, that's what I did but in my file the result is 87. I pasted your calc and got the same result. My date format is DDMMYYYY but I never encountered any limitations in dealing with date string calculations. Anyway I manage to use your file in relationship with another one.

Thank you