exclude last day of each month

[Gieorgie]

Hey Guys !

Is it possible to write a function to a condition, e.g. Where, which will turn off the last days of the month, ie. If the last day of December is 2021-12-31, I would like my condition not to be excluded?

	when/where datepart(t1.PRP_END_DATE) IS NOT NULL and datepart(t1.PRP_END_DATE) - &gv_date_dly. >=0 and ( function ) THEN 'A' 

for example like a below : ?

     ,intnx('month',datepart(t1.PRP_END_DATE),-1,'e') format=yymmd7. as POLICY_VINTAGE,

[PaigeMiller]

I would imagine something like this would work

where your_date_variable ne intnx('month',your_date_variable,0,'e')