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

2 posts / 0 new
Last post
skoglundjeremy
Offline
Joined: 11/17/2022 - 10:00
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.

klmi
Offline
Joined: 02/13/2019 - 08:41

Maybe the following link will help, how to work with date values:
https://ideascripting.com/forum/view-date-values
To extract the data you will only need to use the last day of the previous month as criteria.