Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date math on Datetime()
Message
 
To
04/06/2003 07:26:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00796076
Message ID:
00796084
Views:
15
Gaylen
If you need the Date portion of a DateTime field, just use the TTOD function. In your case, you could use: TTOD( BindDate ) + 30 .
If you need the time portion, by the way, check out the TTOC function.

HTH
Jaime


>Have 2 fields in a report - Binddate and Binddate + 30. Binddate is Date field in table. Client now wants date and time in the report so I changed Binddate field to datetime in the table and now both field show the same date as opposed to the second field incrementing by 30 days.
>
>Any suggestions?
>Gaylen
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform