HOWTO: Add or Subtract Time with a DateTime Data Type

ID: Q176043

The information in this article applies to:

Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0
Microsoft Visual FoxPro for Macintosh, version 3.0b

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)

Additional query words: datetime day hour minute second hh:mm:ss

Keywords : kbnokeyword kbMAC kbVFp300 kbVFp300b kbVFp500 kbVFp500a kbVFp600
Version :
Platform :
Issue type : kbhowto