Sam wrote on 09/15/2009 10:06 ET :
> I have a text field in a table for a data and time - the time is
> importing as 9/5/2006 11:54:03:257.
>
> I need to have the data formated as MM/DD/YYYY, using the example
> above the date/time of 9/5/2006 11:54:03:257 should be 09/05/2006.
>
> Please help with a formula to change this date with in a query.
>
> thanks
>
hello,do you know the all types of information or every thing about
information
go directly on data format click here
http://documentcollaboration.org/