Scripting

Does anyone have any ideas on how we could say create ""blackout"" dates for a date field in essentially we're trying to stop employees from promising dates that are on weekends or holidays. My thought was some how to tie to a UDT, but maybe you all have a better idea.

Script, column pre-validate. Open up your UDT with a list of disallowed dates, and if the entered date is found: SetError.

I would create the table only for holidays. You can use a function to return weekdays.

Talk to Patrick Genualdi at SWK. He wrote a customization for one of our clients that calculated a ship date based on working days (no weekends or holidays)

See if the attached script helps you out. It was set up to read from a UDT to return the number of ship days for the value in the ShipVia field and then calculate the next available ship date on the next business day so it excludes weekends.

Thanks guys I'll give David's method a review and see what i can do with that. if not I'll try Patrick.