Skip to main content

Extracting Records Where Date does not equal last day of previous month

I am new to this forum and to IDEA, so I apologize if this has been discussed before or is fairly easy to do, but I am trying to do a direct extraction of any records that have a date field that does not equal the last day of the previous month (i.e. if I run the extraction today on 11/17/2022, I want all records where the date field is not 10/31/2022).  I am trying to write the formula in a way that I will be able to automate the extraction going forward with a script.  Any help would be appreciated.