where clause

[capriconuser]

i have this script 

select *

from where

as_at_date <> date('30-jun-2018') and name <> 'abc' and s_name <> 'group'

i dont want data only for 30-jun-2018 against name 'abc'

 i did this but this is not working 

[Arthur_Fong · Accepted solution]

Try:

text(as_at_date) <> '30-jun-2018' and name <> 'abc' and s_name <> 'group'

[Gysbert_Wassenaar]

Can you explain how it's not working?

What is the source data, the result you now get and the result you want to get?