dear friends,i have a form that contain two fields(with type date/time).
the first fields named it “starttime” and the second fields named it “end time”.
please tell me how if i want someone choose field “startime” greater than “endtime”, then it appears a messagebox “You type a wrong endtime”. also i want to highlight the “endtime” field
thanx for answering my question
Subject: form with fields
Hello Friend
Step 1) in Date field 1 i.e stdate
place the below code in field validation event as
@If(stdate=“”;@Failure(“Enter the Start”);@Success)
Step2) in the Date field 2 i.e enddate
place the below code
@If(enddate=“”;@Failure(“Enter the Start”);@If(@BusinessDays(stdate;enddate)<1;@Failure(“Select the enddate greater then start date”);@Success));
Subject: RE: form with fields
No need to use @BusinessDays - you can simply have the condition StartDate > EndDate.
i.e. the startdate field has this validation formula:
@If(StartDate = “”; @Failure(“Please enter a start date”); @Success)
The enddate field has this validation formula:
@If(EndDate = “”; @Failure(“Please enter an end date”); StartDate > EndDate; @Failure(“Please enter an end date later than the start date”); @Success)