Well, there is no one "valid DATE Type", unfortunately. Every application has it's own standard :-\
But to get a date that Sql Server didn't reject, we had to remove the Day of Week portion, such as "Mon", "Tue", etc. I think that was all it took. Dave > -----Original Message----- > From: auth admin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 10:53 PM > To: [EMAIL PROTECTED] > Subject: (RADIATOR) DATE > > > We have made our custom windows app to access RADUSERS table, the > fields > VALIDFROM and VALIDTO are integer types. What is the formula > to convert > these fields to a valid DATE Type, so we can automatically > manage valid > dates of the accounts we create. > > chris === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.