Revisiting addMinutes (and all add with day, hour etc.)
Posted: 23 Sep 2017 13:46
Hello,
I give up. I just can't make a simple addMinutes to work.
Tested:
Upon displaying on screen I get:
date_now=0828
min_added=120828
Then I tested:
results in:
min_added=120828
So, my questions:
1. in addMinutes( Date d , Number a)
what should be coded for Date d
2. Why am I getting as result, after adding 2 minutes the value Date d, 120828?
3. Where the 12 came from?
4. Why after adding 2 minutes still shows 120828?
REQUEST:
Can someone show me an example that works as expected. Please don't tell me to use Debug. It's useless in this case.
Thank You
Husky
I give up. I just can't make a simple addMinutes to work.
Tested:
Code: Select all
date_now="{getDate(), dateformat,hhmm}";
min_added= addMinutes(date_now, 2);
date_now=0828
min_added=120828
Then I tested:
Code: Select all
min_added= addMinutes("{getDate(), dateformat,hhmm}",2);
min_added=120828
So, my questions:
1. in addMinutes( Date d , Number a)
what should be coded for Date d
2. Why am I getting as result, after adding 2 minutes the value Date d, 120828?
3. Where the 12 came from?
4. Why after adding 2 minutes still shows 120828?
REQUEST:
Can someone show me an example that works as expected. Please don't tell me to use Debug. It's useless in this case.
Thank You
Husky