Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you add a month to datetime()
Message
From
19/07/2006 20:15:38
 
 
To
19/07/2006 04:05:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01137516
Message ID:
01137897
Views:
14
>>How do you add a day or a month to a datetime? Do you have to convert things to seconds like below, or is there a better way?
>>
>>
>>dt1 = datetime()
>>* Add 2 months:
>>nseconds = 2*31*24*60*60
>>?dt1, dt1 + nseconds
>>
>>
>>Cyril
>
>One solution:
>lnMonth=1 && number of months
>dt2=Datetime() + ((Gomonth(Date(),lnMonths)-Date())*24*60*60)
Thanks for the pointer to Gomonth().
Cyril
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform