Qlik Community

QlikView Documents

Documents for QlikView related information.

Function fMonthDiff between two dates.qvw

richard
Contributor

Function fMonthDiff between two dates.qvw

Hey guys,

This app is follow up example of the function to calculate the difference in months as described in Calculating Months difference between two dates

The function in that discussion is good but is doesn't provide the results for more specific startdates and enddates. When the startdate or enddate is the first or last day the month it calculates 1 excessive month.

I built a small app to calculate the difference in months for different scenario's of a startdate and/or enddate.

Feel free to improve or give any suggestions on the version...

Labels (2)
Attachments
Comments
ecolomer
Honored Contributor II

Good !!

saurabh5
Contributor II


This is  really a nice function to have for calculating difference...

Version history
Revision #:
1 of 1
Last update:
‎01-05-2015 10:51 AM
Updated by: