yyyy-mm-dd and only yyyy in 1 column

[ShantanuDagar]

Hello,

I want to filer a column to exclude values in last 6 months from today's date

The values in column are either just yyyy or yyyy-mm-dd in string data type.

When I am trying to do, it's working fine for the latter type of values but gives null for the yyyy type.

Thanks for any help

[binuacs]

@ShantanuDagar The yyyy formatted field value you need to convert to into date format before applying the filter