Getting Minute

HCL Domino Domino Forum
1

Hi

@If(!@IsTime(DStartDate_2) | !@IsTime(DStartTime_2) | !@IsTime(DEndDate_2) | !@IsTime(DEndTime_2); @Return(“”); “”);

Validate1:=@Date(@Year(DStartDate_2);@Month(DStartDate_2);@Day(DStartDate_2);@Hour(DStartTime_2);@Minute(DStartTime_2);@Second(DStartTime_2));

Validate2:=@Date(@Year(DEndDate_2);@Month(DEndDate_2);@Day(DEndDate_2);@Hour(DEndTime_2);@Minute(DEndTime_2);@Second(DEndTime_2));

nHours:=(Validate2-Validate1)/3600;

modulo:=@Text(@Integer(nHours/24));

hours:=@Text(@Modulo(nHours;24)) +“Hour(s)”;

days_hours:=@Text(@Integer(nHours/24))+ “Days”+@Text(@Modulo(nHours;24)) +“Hour(s)”;

value:=@If(modulo=“0”;hours;days_hours);

value

I am getting Day and hours !!! How can i get minute from above !!!

dev

2

Subject: Getting Minute

Really!?!?

Validate2-Validate1

Gives you the number of seconds between the two dates.

So the number of minutes would just @interger( (Validate2 - Validate1)/60 )

I’m guessing you really want the number of minutes AFTER you figured out the number of days and hours.

Then you could just do

minutes := @interger( @Modulo( (Validate2-Validate1); 3600) / 60 )