Transform the seconds retained from Time.subtract() back into Years, months, days, hours, minutes, seconds

Here's a simple function that converts seconds in to a string with hh:mm:ss to get you started.  Adding days is straight forward, but months get tricky as they vary from 28 to 31 days.

    function toHMS(secs) {
    	var hr = secs/3600;
    	var min = (secs-(hr*3600))/60;
    	var sec = secs%60;
    	return hr.format("%02d")+":"+min.format("%02d")+":"+sec.format("%02d");
    }

Thank you very much for your help!
That's already a lot!

I think that I will also find a way to calculate the months

hi, it willbe very difficult since a month is not a real time value.

have you tried to pass the result into a dateInfo and get .month - 1 ?

if you get the number of month, you have to substract it to the number of day also.

you could do alos a big loop (but will take lots of resources)

like this

Let say ND is the value of your substract.

let say T = day of today (i.e 16)

nMo = 0;

var oneDay = new Time.Duration(86400);

for(var i=1;i<ND;i++){

       if(Gregorian.info(Time.now().substract(oneDay), Time.FORMAT_MEDIUM).day==T){nMo=nMo+1};

}

It will be hard, as not only do months have a 28-31 days, but Feb can have 29 in a leap year.

Hi Shent-Aurkhan,

thank you for your reply.

That options sounds good but I am not sure what you mean in Monkey C. I didn't find a dateInfo casting option. Can you give an example or show me in the docs where I can find this option?

hi, sorry, I meant Time.Gregorian.info

Thanks for the quick reply. And how do I paste it smartly from my seconds into a Time.Gregorian.info?

And I don't think that I completely understood your big loop can you maybe explain what you mean by "ND is the value of your substract". Hence, which substract?

Man, I never thought calculating with time could become this complex ^.^ thanks for your help.

hi, the result you have in seconds for the remaining time.

 can now calculate the difference between two dates in seconds

that is normal, like Jim said, a month is not accurate, it can be 28 or 29 or 30 or 31

month is not a real time value