Date convertion

A

alleho

Member
Joined
Jan 29, 2004
Messages
12
Location
england
Hi,
Im 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
 
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
 
Back
Top