conversion of a char data type into a datetime data type resulted in a out of range datetime valueRSS

1 reply

Last post Aug 22, 2004 08:24 PM by mcaizpp2

  • conversion of a char data type into a datetime data type resulted in a out of range datetime valu...

    Aug 22, 2004 03:10 PM|mcaizpp2|LINK

    hi I have this page that selects all records from a table if the startdate is less than todays date and if the end date is greater than todays date. if somebody links through to the page with the code from page 1, no error but if someone links through from page2 they'll get the error - The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Can anyone explain why it errors on some pages but not on others? Thanks in advance.
  • Re: conversion of a char data type into a datetime data type resulted in a out of range datetime...

    Aug 22, 2004 07:30 PM|mcaizpp2|LINK

    Hi fixed this problem know, so don't worry about it. On certain pages they were changing the session.lcid to 2057 for U.K. so when they linked to particular pages that did queireies based on dates it all got screwed up!