Extracting Records Where Date does not equal last day of previous month
skoglundjeremy
Forums
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.
Maybe the following link will
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.