Hi Team,

Can we identify the weekday or which day in SFMC tool through SQL, The scenario is, i need all the records who is having meeting date on Wednesday and Thursday by last Friday it self.

Is this query works?

EX:

WHERE

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

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

(CAST(T1.[Meeting Start Date] AS DATE) = CAST(DATEADD(Day, 4, GETDATE()) AS DATE) OR

CAST(T1.[Meeting Start Date] AS DATE) = CAST(DATEADD(Day, 5, GETDATE()) AS DATE) OR

CAST(T1.[Meeting Start Date] AS DATE) = CAST(DATEADD(Day, 6, GETDATE()) AS DATE))