did a few searches and majority of the searches were ones excluding weekends and holidays. so im trying to put together a query where I need to pull prior business day (mon-fri). where im trying to figure out is if I can do this in a query/SQL or in a module? basically I need to return prior day but if today is Monday for example, then prior business day would be Friday but I need to include the weekend data in with Friday. what's even more of a moneky wnrech in the gears are holidays. some like this past memorial day is on a Monday so if today was tueday then I need to get data from fri-mon. so I imagine I would need a table strictly for holidays correct (or maybe have a table with just weekends and holidays) and use an inner join with the table im pulling from? hopefully this make sense at all?