I have a Multi-Select Day of the Week field on a Custom Record that I want a Saved Search to evaluate that todays date is one of the days selected. I built my formula yesterday and it worked great, I thought I was all set. When I ran it today, anything with 'Thursday' selected was not showing up. The idea was to have this text formula to not be empty as the criteria. _REGEXP_SUBSTR({custitem_item_class.custrecord_retail_floor_transfer_day},TO_CHAR({today}, 'Day'))_ Does anyone have any idea why Netsuite only recognizes Wednesday??

Curious, what happens if you do {today}-2 or -3?

So I did try and test this by adding/subtracting days and Wednesday is the only one that works.

That's really weird - and I'm getting the same on my end. Had a thought though, why not use `INSTR()`as your criteria?

I am still learning these functions, how would that be used in this case?

Thanks for your help!