Discussions
Script search on date blew up today
I have a scheduled script that has been running on a daily basis for nearly a year now.
It essentially does a search of all records that have an end date 'before today' to find expired records and another search of all record that have a start date of 'onorbefore today' and an end date 'after today'.
Has worked flawlessly for nearly 12 months. Today's script ran as usual and instead of finding the 1 or 2 records it usually finds and processing them, it found EVERY record and processed them.
Has something changed that effects date searching? I need to know as nothing has changed on my part and for the script to fail as it did is *very* concerning.