Trying to substrata one date from another

Posted by Rollbase User on 06-Feb-2013 13:24

Need your help with a formula I'm trying to subtract one date from another so I can get a total days difference between two dates Formula: var d = new Date("{!ler_date#iso}"); var c = new Date("{!actual_time_of_arrival#iso}"); return d.getDate() - c.getDate(); All I get is NULL

All Replies

Posted by Admin on 06-Feb-2013 14:44


You should not use #iso when setting a date.

I would do it this way:

var d = new Date("{!ler_date}");

var c = new Date("{!actual_time_of_arrival}");

return (d.getTime()-c.getTime())/24/3600/1000;

Posted by Admin on 07-Feb-2013 01:18


Thank you for your help! It worked.

Small note to all who is just starting with programming Rollbase -

I was trying to subtract day from one related Object from another day from another object

For that I created template field and imported related date in Java Script format (#js)


Only then I was able to get this formula working.

This thread is closed