var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help to Calculate Due After time in a List box
I Have a form on which Pending cases will be shown from a particular excel sheet.
I have already calculated the Elapsed time in the query and I need to calculate Due After field:-
Due After would be :- Opened Time +SLA(usually 1 day which will be selected from combobox)+Time Extension
Can someone help me how to calculate Due After field.
I have attempted this one but this doesnt work:-
In Query design view:-
Due After1=Format(Issues.[Opened Time]+1+Issues.[Time Extension])
In the above field Time Extension is a Number of hours the time will be extended. SLA for 24 hours(1 day added).
Any Help would be appreciated.