How can i get the time in hour minute & second by substracting 2 Date/Time Field.
plz help me out thanx in advnce.
waiting 4 yr reply
How can i get the time in hour minute & second by substracting 2 Date/Time Field.
plz help me out thanx in advnce.
waiting 4 yr reply
Subject: How can i get the time in hour minute & second by substracting 2 Date/Time Field
Hi,
difference& = notesDateTime.TimeDifference( notesDateTime )
or
difference# = notesDateTime.TimeDifferenceDouble( notesDateTime )
finds the difference in seconds between one date-time and another (NotesDateTimeClass)
Now compute the days, hours, minutes and seconds…
HTH Oliver
Subject: How can i get the time in hour minute & second by substracting 2 Date/Time Field
a:=@If(SF_NextCall_Time!=“”;SF_NextCall_Time-SF_Info_Receive_Time;“”);a;
b:= @Integer(a/3600);
@If(SF_NextCall_Time!=“”;@SetField(“Hour”;@Text(b));“”);
c:=@Modulo(@Integer(a);3600);
d:= @Integer(c/60);
@If(SF_NextCall_Time!=“”;@SetField(“Minute”;@Text(d));“”)
by this i have solved the problem u can refer it