Skip to Main Content
Bulk Materials Ideas

Idea and discussion portal for the bulk materials product line. Users may submit, view and vote on ideas submitted by all users.

Status Reviewing
Categories Ticket
Created by Simon Edwards
Created on Oct 19, 2017

Better Messaging for datediff overflow

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.

  • Attach files
  • +1