From: jmose@mapson.attglobal.net   
      
   Jim & O.P.,   
      
   >One has to have their bde date setting matching this format, otherwise you   
      
   >would have to manipulate this input to mathc your setting and then you can   
      
   >use normal date/time functions.  Bring it in to your code as a string value,   
      
   >break it down into date and time pieces, convert to match your bde setting   
      
   >and you should then have valid date/time fields.   
      
   In addition, remember that you can cast a date as date(mm, dd, yyyy), where   
   each is an integer.  Unfortunately, you can't do the same with a time.  This   
   will let you ignore the date bde setting.   
      
   And, I agree that it is much easier to split the dateTime into a date() and   
   a time() component to work with.  In the end, just merge them back together   
   using:   
      myDateTime = dateTime(myDate) + time(myTime)   
      
   HTH,   
   Jim Moseley   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)