splitting data

[poz]

I need to split the date and time contained in 1 field to 2 new seperate fields. I have created 2 new fields. One called date and the other called time. The current data formats like this 7/5/2008 11:27:32 Pm. Is ther an easy way to split that into the new fields I created. Any and all help greatly appreciated. I am using FM Pro 8 Advanced.

Thanks

[Lee Smith]

It has been a long time since I worked in v8, but I believe that GetAsDate ( text) might do it for the date, and GetAsTime ( text ) for the Time.

Be sure that they return the Results of Date and Time respectively.

HTH

Lee

Edited July 9, 2008 by Guest

[poz]

OMG! How easy was that. Lee are the man. Many thanks.