Topic: MonthBetweenMonth How To Cal Result is Number

How To Query in SQLITE
Month Between Month : Result  -1,0, . . . 999
Example
'2016-01-01' - '2014-01-01' = 24
'2016-01-01' - '2015-10-01' = 3
Help me please

My Visual Database : I Love You
Easy For Beginner Student For Me

Re: MonthBetweenMonth How To Cal Result is Number

A useful resource: https://www.sqlite.org/lang_datefunc.html

Re: MonthBetweenMonth How To Cal Result is Number

It Haven't cal month between month because

-result month is name month or 01-12  not number format 00...9999

in  mvd script editor have function MonthsBetween(,) but sqlite query have ???
Um... Help me please

My Visual Database : I Love You
Easy For Beginner Student For Me

Re: MonthBetweenMonth How To Cal Result is Number

Try this query,

SELECT round((julianday(datefield1) - julianday(datefield1))/30) as MonthsDiff from TableName;
Dmitry.