How To Add or Subtract Time with a DateTime Data Type (176043)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b
  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 5.0a
  • Microsoft Visual FoxPro for Windows 6.0
  • Microsoft Visual FoxPro for Macintosh 3.0b
This article was previously published under Q176043

SUMMARY

This article describes how to add or subtract time with a DateTime field. Time, in seconds, can be added or subtracted with a DateTime data type field. Time carries over from seconds to minutes to hours to days and to years. There are no adjustments in this sample for a leap year. This is an example and you may want to add additional functionality if time calculations are a large part of your application.

MORE INFORMATION

When you add or subtract time with a DateTime field, the value(s) to add or subtract will be calculated with seconds.

Example to add an hour: 
   HourFromNow = Datetime() + 3600
-or-

Example to subtract a week: 
   WeekAgo = Datetime() - (7*24*3600)
(c) Microsoft Corporation, 1997, All Rights Reserved. Contributions by Mike Fernald, Microsoft Corporation
Modification Type:MinorLast Reviewed:6/29/2004
Keywords:kbhowto KB176043
©2004 Microsoft Corporation. All rights reserved.