Is there an way to use an MySQL query to find the missing months between 2 dates in an table?

yes, it's easy if you use an auxiliary numbers table...
could you do a SHOW CREATE TABLE for your table please?

It's about this table:

CREATE TABLE IF NOT EXISTS `iso_werkplekinspecties` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`datum` date NOT NULL,
`ehbo_doos` varchar(3) NOT NULL,
`looppaden` varchar(3) NOT NULL,
`blus_app` varchar(3) NOT NULL,
`nooduitgang` varchar(3) NOT NULL,
`geluidsniveau` varchar(3) NOT NULL,
`potentieel` varchar(3) NOT NULL,
`pbm` varchar(3) NOT NULL,
`loopgang` varchar(10) NOT NULL,
`verlengkabel` varchar(10) NOT NULL,
`afval` varchar(10) NOT NULL,
`positie` varchar(10) NOT NULL,
`opmerkingen` varchar(255) NOT NULL,
`status` varchar(15) NOT NULL,
`user_id` int(2) NOT NULL,
`user_id_rejected` int(2) NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

This is my date field:
`datum` date NOT NULL,

Thanks for helping me out!!

find the missing months between which two dates?

Date one is the oldest date in the field 'datum'. The second date is NOW() + 3 months.

okay, we'll get there, in stages

could you please run this query and report what it produces...