Weekly Summary Report

SELECT SubscriptionCode, MagazineTitle FROM View_GetMagazineTitles WHERE DateSubscribe>=CONVERT(DATETIME,'2012-07-01 00:00:00',102) AND DateSubscribe < CONVERT(DATETIME,'2021-07-01 00:00:00',102) GROUP BY SubscriptionCode, MagazineTitle ORDER BY SubscriptionCode;

Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid column name 'DateSubscribe'.

/HistoryActivationByMonth-Auto.asp, line 48