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.
Last seen: 1 month 1 week ago
Joined: 11/17/2022 - 10:00
Maybe the following link will help, how to work with date values:
To extract the data you will only need to use the last day of the previous month as criteria.