Saved search formula to get transactions created before a specific time

The formula CASE WHEN ROUND((({today}-{datecreated})*1440),6) > 15 THEN 1 ELSE 0 END”, “equalto”, “1”] can be used to exclude the transactions which are created 15mins before the script execution. This formula becomes useful when we are running scripts in a schedule of 15 minutes of less where a record may have completed its creation before the script schedules starts.

Leave a comment

Your email address will not be published. Required fields are marked *