get date on specific countdown or advance

Discussions about CSEntry
Post Reply
iip
Posts: 32
Joined: January 19th, 2012, 11:30 pm

get date on specific countdown or advance

Post 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-
Gregory Martin
Posts: 1792
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: get date on specific countdown or advance

Post by Gregory Martin »

You could get the date 150 days ago by writing:
dateadd(sysdate("YYYYMMDD"),-150)
iip
Posts: 32
Joined: January 19th, 2012, 11:30 pm

Re: get date on specific countdown or advance

Post by iip »

aha!

thanks a lot Greg!

Best,

-iip-
iip
Posts: 32
Joined: January 19th, 2012, 11:30 pm

Re: get date on specific countdown or advance

Post 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-
Gregory Martin
Posts: 1792
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: get date on specific countdown or advance

Post 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
iip
Posts: 32
Joined: January 19th, 2012, 11:30 pm

Re: get date on specific countdown or advance

Post by iip »

Thank you Greg!

Best,

-iip-
Post Reply