Hi Team,

Actually I'm pulling the records exact 4 days before the meeting date on daily basis whose RSVP = 0. IF the meeting date comes on Wednesday or Thursday , since these records will fall under Saturday and Sunday . i just need those records to be pulled on Friday only. (On Friday i need Friday , Saturday and Sunday records)

WHERE

(DATENAME(dw, T1.[Meeting Start Date]) ='Wednesday' OR

DATENAME(dw, T1.[Meeting Start Date]) ='Thursday')

AND T1.[Meeting Start Date] >= GETDATE()

AND T1.[Meeting Start Date] <= DATEADD(WEEK, 1, GETDATE())

what needs to be chaged in the query