Post Reply 
DDAYS in the solver
10-21-2016, 07:46 AM
Post: #1
DDAYS in the solver
Hi,
I try to use the DDAYS command in the solver but get always "Bad Guess(es):
E1: A=DDAYS(D1;D2)

D1:2006,1010
D2:2006,1111

A: 1,0000 as seed

Any clue?
Thx.
Kr.,
Bvr
Find all posts by this user
Quote this message in a reply
10-21-2016, 03:15 PM
Post: #2
RE: DDAYS in the solver
(10-21-2016 07:46 AM)Bvr Wrote:  Hi,
I try to use the DDAYS command in the solver but get always "Bad Guess(es):
E1: A=DDAYS(D1;D2)

D1:2006,1010
D2:2006,1111

A: 1,0000 as seed

Any clue?
Thx.
Kr.,
Bvr

I'm guessing this would not work in the solver due to it not being a continuous function with no derivative. I'm pretty sure the same limitation would have been in the 48 series too.

TW

Although I work for HP, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
10-21-2016, 04:54 PM
Post: #3
RE: DDAYS in the solver
(10-21-2016 04:32 PM)moonbeam Wrote:  If the arguments of DDAYS are given, the function value is a constant. Solver can handle this just fine :-) Looking for the start or end date is another matter, best left to DateAdd(date,ndays).

Yes, you are right here of course. I was specifically thinking the "solve for any of the variables" aspect part of the solver like you point out. Thanks for the clarification!

TW

Although I work for HP, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
10-24-2016, 07:47 AM
Post: #4
RE: DDAYS in the solver
Thanks guys,
I used Dstart and Dend and it works perfect now.

Kr.,
Bvr
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)