Page 1 of 1

get date on specific countdown or advance

Posted: June 12th, 2013, 1:05 pm
by iip
Hi All,

As subject, I want to get date on countdown or advance, for example what date was on 150 days ago?
this similar to sysdate()-150, thanks in advance,

Best,

-iip-

Re: get date on specific countdown or advance

Posted: July 1st, 2013, 6:14 pm
by Gregory Martin
You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)

Re: get date on specific countdown or advance

Posted: July 1st, 2013, 6:43 pm
by iip
aha!

thanks a lot Greg!

Best,

-iip-

Re: get date on specific countdown or advance

Posted: July 1st, 2013, 6:51 pm
by iip
Gregory Martin wrote:You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)
I'm using CSPro 5.02, why I got error:

ERROR: 'dateadd' is not a declared variable or is a misspelled dictionary entry

Am I missing something Greg?

-iip-

Re: get date on specific countdown or advance

Posted: July 2nd, 2013, 8:52 am
by Gregory Martin
Oh, I guess that this is only in the beta 5.0.3 version of CSPro. You can download it here:

http://csprousers.org/201305/cspro50.exe

Re: get date on specific countdown or advance

Posted: July 2nd, 2013, 11:46 am
by iip
Thank you Greg!

Best,

-iip-