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-
get date on specific countdown or advance
-
- Posts: 1792
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: get date on specific countdown or advance
You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)
Re: get date on specific countdown or advance
aha!
thanks a lot Greg!
Best,
-iip-
thanks a lot Greg!
Best,
-iip-
Re: get date on specific countdown or advance
I'm using CSPro 5.02, why I got error:Gregory Martin wrote:You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)
ERROR: 'dateadd' is not a declared variable or is a misspelled dictionary entry
Am I missing something Greg?
-iip-
-
- Posts: 1792
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: get date on specific countdown or advance
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
http://csprousers.org/201305/cspro50.exe
Re: get date on specific countdown or advance
Thank you Greg!
Best,
-iip-
Best,
-iip-