How Do I Get the Number of Months Between Two Dates?

[Anonymous]

Hi all,

I am still lost in number of months between dates expression.

Being New to QV & Scripting but is been like thrown into the deep end.

this question was raised by @Jonathan Shaltz earlier

  Data set i have:

Start Date	Completed Date
21-Mar-1997	31-Dec-2030
01-Jun-2010	31-Dec-2030
10-May-2013	31-Dec-2030

1. find the number of months between the dates
2. find the number of Years between the dates
3. Do not load/(drop) data below certain year stamp

@Jonathan Shaltz

[atoz1158]

Hi Tony

Try replacing your highlighted line with the following

((Year([Completed Date])*12) + Month([Completed Date])) - ((Year([Start Date])*12) + Month([Start Date])) As MonthDiff,

[Anonymous]

Hi Adrian,

thanks so much

Tony