alleho Posted February 19, 2004 Posted February 19, 2004 Hi, I'm using .net with a foxpro8 backend. In my table I have a BATCH field that contains a 'sort of Julian date'.ie 46 is 6th January 2004 & 3365 is 31st Dec 2003. I need to sort these so I have the oldest first and newest last. I have used the datepart functions while validating input but can�t work out how to get this to work in this case and convert to a real date. I think converting to a real date is the easiest way to do this but if you have any other thoughts...... Thanks Quote
Administrators PlausiblyDamp Posted February 19, 2004 Administrators Posted February 19, 2004 Could you explain how the dates are converted inito those numbers? n Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
alleho Posted February 20, 2004 Author Posted February 20, 2004 They are never dates just a four digit number ie 4051 is today. Dont worry too much I think I have found a way round it by have 2 indexes !1) order on first digit 2) order last 3 digits. Think this will work. #Thanks Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.