Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Alex Nocete
  Where is Alex Nocete?
 
 Philippines
 Alex Nocete
 Tags
Subject: RE: split datetime()
Thread ID: 310808 Message ID: 310868 # Views: 45 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, June 26, 2011 12:08:17 PM         
   


> >
> > 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
This is why.

Datetime1 - datetime2 = seconds difference.

The whole datetime is exactly what you need.
The DateTime datatype has a number of VFP functions for your purpose.
The Time string alone has no special functions at all in VFP.
-Anders

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