Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date math on Datetime()
Message
From
04/06/2003 09:04:06
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
04/06/2003 07:54:19
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00796076
Message ID:
00796114
Views:
20
>>>Have 2 fields in a report - Binddate and Binddate + 30.

>>
>> Binddate + (30*24*3600)
>>
Hi Gaylen,

Addition and subtraction apply to days with date data types and seconds with datetime data types.

From the "Date and Time Operators" topic in Help:
Date and Time Operators

Operator Action Code 
+   Addition       tNewTime = tTime1 + nSeconds
                   dNewDate = dDate1 + nDays
 
-   Subtraction    nSeconds = tTime1 - tTime2
                   tNewTime = tTime1 - nSeconds
                   dNewDate = dDate1 - nDays
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform