>I have two fields in my table: swipedate (character 8) and swipetime (character 4)..
>
>I'd like to display it in my form like: 07/15/2009 03:53:20 PM
>
>How do i do that?
So is the swipedate 07152009 or 07/15/09? Also, how are you fitting the time down to the second in a 4 character length field? Either it is simply 0353 or some other scheme that you haven't indicated. In either event after you're done parsing/combining the two character fields into something that looks like your example above you would simply use CTOT("07/15/2009 03:53:20 PM") to receive a datetime data type.