Hi Anthony,

It worked. Can I use the column name which is New_Date in the Where clause?

What I'm aiming now is If there are profiles that is tagged DateEffective...

Hi Anthony,

Thanks for the quick reply. Can you tell me how can I use or insert the ab.DateEffective into the Case?

CASE

WHEN ab.DateEffective = 1 THEN 'SUNDAY'

WHEN ab.DateEffective...