Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 To: Alex Nocete
  Where is Alex Nocete?
 
 Philippines
 Alex Nocete
 Tags
Subject: RE: split datetime()
Thread ID: 310808 Message ID: 310825 # Views: 46 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Saturday, June 25, 2011 6:50:44 PM         
   


> hello all,
> I need help, i have a table with this format
> |idno|datetime |
> |001 |06/25/2011 13:23:00|
> |002 |06/25/2011 14:24:00|
> |003 |06/25/2011 15:25:00|
>
> i would like to separate it like this
> |idno|date |time |
> |001 |06/25/2011 |13:23:00|
> |002 |06/25/2011 |14:24:00|
> |003 |06/25/2011 |15:25:00|
>
> Please help me with the codes.
>
> Thanks,
>
>
> Alex Nocete

DO NOT BREAK THEM INTO TWO FIELDS! You will easily be able to show the user one or two textboxes.

Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.

ENTIRE THREAD

split datetime() Posted by Alex Nocete @ 6/25/2011 9:26:11 AM
RE: split datetime() Posted by Samir H. @ 6/25/2011 9:40:31 AM
RE: split datetime() Posted by Mike Yearwood @ 6/25/2011 6:50:44 PM
RE: split datetime() Posted by Alex Nocete @ 6/26/2011 11:00:39 AM
RE: split datetime() Posted by Anders Altberg @ 6/26/2011 12:08:17 PM
RE: split datetime() Posted by Cetin Basoz @ 6/26/2011 1:09:37 AM