Calculating a number between two dates

[harrietohs]

Using Crystal 8.5

I am trying to construct a formula that will show me a numeric value that represents the number of months between a specific month and current month.

For example:

If the month in the date field called {date_seen} is Sept.
and the current month is November, the number I need to see is 3. Is it possible via a formula?

Thanks,

Harriet

 

[Turkbear]

Hi,
In the help files, look at the DateDiff functions..

For Instance:

Use DateDiff with the "m" parameter to find the number of months difference between two dates.

DateDiff ("m", #3/15/1999#, #7/13/1999#)

Returns 4.



You can take it from there...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[harrietohs]

Great! One more question. I'm not sure how to represent the current month in the formula.

Harriet

 

[synapsevampire]

3 is an odd answer for that, most consider it 2.

Anyway, it sounds like you always add one month, so use:

DateDiff("m", {startdate}, {enddate})+1

-k

 

[synapsevampire]

Use:

DateDiff("m", {startdate}, currentdate)

-k

 

[harrietohs]

Yep, I meant to type 2,not 3.

And thanks, you are amazing. I looked up DateDiff, but found it confusing until I read your post.

Giant thanks!!


Harriet