Function --> intervalds Hello I am using the following expression

aneeshv over 11 years ago

Function --> intervalds

Hello I am using the following expression and collecting info in a Date And Time Variable. It gives me a wrong value. It gives me a backward date .
For e.g. for -->
now()+intervalds(720,0,0)
It gives me-->
May 26, 2013 1:09 AM

Instead of

July 13, 2013 6:14 P.M.

I understand that it returns an Interval.

But my use case is to get a Date and Time from the user, add the days provided by the user and provide the new Date and Time to the user.

What should I use if not this, to achieve it?

My process timezone is GMT.

...

Discussion posts and replies are publicly visible

0 venkateshr over 11 years ago

Did a quick test and looks like the intervalds function works well till 596 hours (roughly 24 days). Anything between the next 24 days (597 till 1191), it gives a date in the 24 days prior to the current date and this is cyclical. I.e. now()+intervalds(1192,0,0) , now()+intervalds(2384,0,0) all give the current date.

For your use case, if the user enters the number of days as an integer, you can simply add now()+days_entered_by_user. You can use the calladddays function if business days are to be considered.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel