Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If([InSite.ST_Date]<"2013-01-01 00:00:00"
Or ([InSite.ST_Date]>="2013-01-01 00:00:00"
And InSite.Inv_Amt>=1000000)
Or ([InSite.ST_Date] Is Null
And InSite.Inv_Amt>=1000000)
Or [InSite.ST_Specialty] In ("Business Owner","Corporate Executive")
Or [NBR.CUSTOMER_NAME]="INV REVENUE < $10"
Or [NBR.ITEM_ID] In ("CM_CRP_FDP"),"QUALIFIED","") AS QUALIFCATION,
If([InSite.ST_Date]<date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')
Or ([InSite.ST_Date]>=date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')
And InSite.Inv_Amt>=1000000)
Or (len(trim([InSite.ST_Date])) = 0
And InSite.Inv_Amt>=1000000)
Or match([InSite.ST_Specialty],'Business Owner','Corporate Executive')
Or [NBR.CUSTOMER_NAME]='INV REVENUE < $10'
Or match([NBR.ITEM_ID],'CM_CRP_FDP'), 'QUALIFIED','') AS QUALIFCATION,
If([InSite.ST_Date]<date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')
Or ([InSite.ST_Date]>=date#('2013-01-01 00:00:00','YYYY-MM-DD hh:mm:ss')
And InSite.Inv_Amt>=1000000)
Or (len(trim([InSite.ST_Date])) = 0
And InSite.Inv_Amt>=1000000)
Or match([InSite.ST_Specialty],'Business Owner','Corporate Executive')
Or [NBR.CUSTOMER_NAME]='INV REVENUE < $10'
Or match([NBR.ITEM_ID],'CM_CRP_FDP'), 'QUALIFIED','') AS QUALIFCATION,
Thank you very much Gysbert.