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-