Thank u Sharona.. I have reached that much.
and I have done a formula for finding out the lunchout.and here it is:
Local DateTimeVar Time1 :={EVENTS.EVENT_TIME_UTC};
stringvar y := Cstr(datepart("YYYY",Time1,0));
Numbervar y1 := Tonumber(y);
stringvar m := Cstr(datepart("M",Time1,0));
Numbervar m1 := Tonumber(m);
stringvar d := Cstr(datepart("D",Time1,0));
Numbervar d1 := Tonumber(d);
DateTimevar PlannedTime1 := DateTime (y1,m1 ,d1 ,12 ,45 ,00 );
DateTimevar PlannedTime2 := DateTime (y1,m1 ,d1 ,14 ,15 ,00 );
if ( EVENTS.EVENT_TIME_UTC>= PlannedTime1 AND ({EVENTS.EVENT_TIME_UTC}<=PlannedTime2)and ({READER.TIMEATT}=2)
then
DateTimeVar out :=DateAdd("h",3,{EVENTS.EVENT_TIME_UTC});
but it is not doing the job,what i required.
Edited by andrewsimon - 27 Jul 2011 at 2:52am