Field Format Question!!

  • Thread starter Thread starter pmsuper
  • Start date Start date
P

pmsuper

Hi,

I have a text field want to change to a time format
from "0303261346" change to "2003/03/26 13:46"
Hope someone can help!!

Thank!!

Gary
 
Format(DateSerial(Left([TextField],2),Mid([TextField],3,2),Mid([TextField],5
,2)) & " " & TimeSerial(Mid([TextField],7,2), Right([TextField],2),0),
"yyyy/mm/dd hh:mm")
 
Thank for help!!

Wayne Morgan said:
Format(DateSerial(Left([TextField],2),Mid([TextField],3,2),Mid([TextField],5
,2)) & " " & TimeSerial(Mid([TextField],7,2), Right([TextField],2),0),
"yyyy/mm/dd hh:mm")

--
Wayne Morgan
Microsoft Access MVP


pmsuper said:
Hi,

I have a text field want to change to a time format
from "0303261346" change to "2003/03/26 13:46"
Hope someone can help!!

Thank!!

Gary
Click to expand...
Click to expand...
 
Back
Top