Salesforce Marketing Cloud SQL

Question

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))

question from:https://stackoverflow.com/questions/66051231/salesforce-marketing-cloud-sql

Answer 1

Waitting for answers