Home > Archive > FoxPro database connector > August 2005 > DATEADD or DATEDIFF function









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DATEADD or DATEDIFF function
John Cosmas

2005-06-15, 3:25 am

I need a function that will take today's date and add X days to it. It
should return the new date after the add.


jabailo@texeme.com

2005-06-15, 3:25 am

John Cosmas wrote:
> I need a function that will take today's date and add X days to it. It
> should return the new date after the add.
>
>


DateTime.Now.AddDays();

( Doesn't .Net rock ? )
John Cosmas

2005-06-15, 3:25 am

I meant to say that I'm programming in VFP 6.0 and not .NET

<jabailo@texeme.com> wrote in message
news:dMydnWKIvbxXPjL
fRVn-sA@speakeasy.net...
> John Cosmas wrote:
>
> DateTime.Now.AddDays();
>
> ( Doesn't .Net rock ? )



Stefan Wuebbe

2005-06-15, 3:25 am


"John Cosmas" <johncosmas@charter.net> schrieb im Newsbeitrag
news:fgNre.690$mD6.431@fe07.lga...
>I need a function that will take today's date and add X days to it. It should
>return the new date after the add.


In VFP you can add the desired number of days as integer to a given date value
dResult = Date() + 5


Please do not crosspost

-Stefan


--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Eric den Doop

2005-06-15, 3:25 am

tomorrow = DATE() + 1
yesterday = DATE() - 1
nextmonth = GOMONTH(DATE(), 1)
lastmonth = GOMONTH(DATE(), -1)

( Doesn't VFP rock ? )
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

"John Cosmas" <johncosmas@charter.net> wrote in message
news:ViOre.4676$eL5.3755@fe04.lga...
>I meant to say that I'm programming in VFP 6.0 and not .NET
>
> <jabailo@texeme.com> wrote in message
> news:dMydnWKIvbxXPjL
fRVn-sA@speakeasy.net...
>
>



Carsten Bonde

2005-06-15, 3:25 am

John,

? Date() + 7 && One week later

--
Cheers
Carsten
____________________
___________

"John Cosmas" <johncosmas@charter.net> schrieb im Newsbeitrag
news:ViOre.4676$eL5.3755@fe04.lga...
> I meant to say that I'm programming in VFP 6.0 and not .NET
>
> <jabailo@texeme.com> wrote in message
> news:dMydnWKIvbxXPjL
fRVn-sA@speakeasy.net...
>
>



bullyman316@yahoo.com

2005-06-18, 8:24 pm

On Wed, 15 Jun 2005 07:47:49 +0200, "Eric den Doop"
< ericdendoop@xspamblo
ckxfoxite.com> wrote:

>tomorrow = DATE() + 1
>yesterday = DATE() - 1
>nextmonth = GOMONTH(DATE(), 1)
>lastmonth = GOMONTH(DATE(), -1)
>
>( Doesn't VFP rock ? )


>( Doesn't VFP rock ? ) AMEN TO THAT!


Olaf Doschke

2005-06-24, 3:24 am

> > DateTime.Now. AddDays();[color=dar
kred]
Yes, it doesn't rock ;-).

At least not in this little aspect, as you can
simply add integers to dates (adding days)
or to datetimes (adding seconds)

wait a minute, wait till
datetime()+60

Bye, Olaf.


newboy

2005-08-11, 3:25 am

code is under here:

function newdate(adddays as integer)
return date()+adddays
endfuction




"John Cosmas" <johncosmas@charter.net> 写入消息新闻
:fgNre.690$mD6.431@fe07.lga...
> I need a function that will take today's date and add X days to it. It
> should return the new date after the add.
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com