Varchar to datetime
Posted on 2002-04-17
I have a sql table in an sql database version 7.0 and i have a CallCenter software called Telephony@Work
CallCenter@nywhere 5.0 but in the table that holds the date of the and time of the call is avarchar
field and the people that make the software toll me to use this formula to convert that field to a valid
Validdate = Date(Value in the field)/86400+Date("1970,1,1")-4/24)
This formula works great on MsAccess but when i try to put this formula in crystal reports i receive an error tellin me that the number of days is too large or is not an integer.
What i am doing wrong.