>how can I convert:
>
>'12/01/2010 12:00:00 AM'
>
>to
>
>'12/01/2010'
>
>thanks for the help.
>
>regards,
>
>Jerry
Is Character or Datetime?
If is Character:
? LEFT('12/01/2010 12:00:00 AM', 10)
If is Datetime:
? TTOD(DATETIME(2010,12,1,0,0,0))
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________