Some exception

[smilingjohn]

Hi All, 

I need to set a where condition in the script while fetching the data  .I am supposed to fetch the data after 2021 . but in the year 2021 I have to consider two  values which is 'SKTR-3098' and 'DMLT-4001' how can I write the where condition for this ? 

Need some suggestion

Where (CreateDate)>2021 ( but consider 'SKTR-3098' and 'DMLT-4001'  in the year 2021) 

Thanks in Advance 

[justISO · Accepted solution]

Hi, maybe use OR condition?, like:

WHERE (CreateDate>2021) OR (CreateDate=2021 AND match([value], 'SKTR-3098','DMLT-4001'))

[MarcoWedel]

If CreateDate indeed is a date, as the name suggests, you might have to use 

Year(CreateDate)>2021

instead of just

(CreateDate)>2021