( Date field) Converting Seconds into days

[aahitha2]

Hi All,

I Have  one date field named as date1 and i need to differentiate this date1 field with current date.

var diff= gs.diff(date1.getDisplayValue(),gs.now().getDisplayValue(),true) ---- Now i need to convert these seconds into days.

var days=parseInt((diff/(60*60*24)));

But not working as expected, it showing one day delay to expected day.

Can any one help.

Thanks,

Aahitha

[Ankur Bawiskar]

Hi,

It is a date field and not date/time field.

Can you tell for example what date are you comparing?

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[ggg]

an example of dateDiff that may help:

var date1 = new GlideDateTime();
var date2 = new GlideDateTime();
date1.setDisplayValueInternal('2014-01-01 12:00:00');
date2.setDisplayValueInternal('2014-01-03 12:00:00');


var diffDays = gs.dateDiff(date1.getDisplayValue(), date2.getDisplayValue(), true);
gs.info(diffDays/(60*60*24)