Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Alex Nocete
  Where is Alex Nocete?
 
 Philippines
 Alex Nocete
 To: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 Tags
Subject: RE: split datetime()
Thread ID: 310808 Message ID: 310867 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, June 26, 2011 11:00:39 AM         
   


> > 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.

thanks mike, but i need it for a payroll program, how can i generate the time the user logged-in and logged off from office if i will not break/split the time from the date.

Alex

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