If a user puts a date on the Load in Dispatch Schedule (New!) (Loads Tab) and possibly in related programs that has an absurd date, such as 7/7/7777 7:07am, either reject the data with a message such as ‘Dates over 365 (System Configuration defined) days in the future are not allowed’ or similar “Invalid Date Entry, try again! , or don’t allow a save. Currently save is allowed and this creates an error on the Dispatch Schedule (New!), DSDispatchInquiry.exe as follows:
The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise date part. [OK]
Although date is mentioned multiple times, most users will choke on this and a support call will result.