Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date math on Datetime()
Message
From
04/06/2003 10:07:33
 
 
To
04/06/2003 09:04:06
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00796076
Message ID:
00796166
Views:
21
Cindy - Looked all through the help and the 'HACK' but never looked for operators and never saw it referenced on other help pages.

I appreciate your responsiveness and help.
Thanks
Gaylen





>>>>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
Reply
Map
View

Click here to load this message in the networking platform