Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody.
I have initial date and final date
i have to make the difference, in expression i put final - initial and its working
but i wanna see this in day and hours, how i make this?
timestamp(InitialDate) - timestamp(FinalDate)
timestamp(InitialDate) - timestamp(FinalDate)
Hi Jeremias,
Here are a few expressions to try out:
SET date1 = "03/04/2014 01:11:12";
SET date2 = "10/04/2014 23:11:12";
//Get the working days
LET testrange = NetWorkDays('$(date1)','$(date2)')-1;
//Calculate the interval with days
LET rangeinterval = Interval('$(date2)'-'$(date1)','D hh:mm');
//Get the time part of the interval
let varTime = Right( '$(rangeinterval)', 5);
//Get the Days part of the interval
let vartempDays = Left( '$(rangeinterval)', Len( '$(rangeinterval)' ) - 6 );
//Create the correct interval - ie: correct days value
let varTimeBetween = '$(testrange) $(varTime)';
All the best .
Mark
www.techstuffy.com
Good! thank you.
I guess it´s timestamp(final) - timestamp(initial) or am i wrong?
Interval([final date]-[initial date], 'dd hh:mm:ss')
Thank you! I guess the timestamp function works too. Am i right?
Cheers
Try it!
=interval(final-initial,'D hh:mm')