Query: Qry Get Marketing Sub Campaign Expire 2 Days

Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

• Marketing Campaigns
• Principal Projects
• Marketing Sub Campaigns
• Lead Types
• Marketing Sub Campaign Lead Types
• Principals

Where Clause

(((DateDiff(\"d\",Date(),[Marketing Sub Campaign End Date]))>0 And (DateDiff(\"d

SQL

(((DateDiff(\"d\",Date(),[Marketing Sub Campaign End Date]))>0 And (DateDiff(\"d