Re: time validation

jdecker — Mon, 27 Oct 2008 13:00:37 GMT

thanks worked like a charm.

Re: time validation

santhoshp — Thu, 23 Oct 2008 07:05:18 GMT

Hi,

Use the following data validation on begin_time field.

msxsl:string-compare(., ../preceding-sibling::d:tbl_Entry[1]/@end_time) <= 0

time validation

jdecker — Wed, 22 Oct 2008 14:52:52 GMT

hello all and thanks in advance for your help. This is my first time using infopath and I am slowly learning as I go.

I am creating a timesheet form with a repeating section. The section has fields for pay_rate, begin_time, end_time, vehicle_num etc. What I need to happen is when the section is repeated I need to make sure that begin_time on section2 is not before end_time on section1, begin_time on section3 is not before end_time on section2 and so on and so on. The form is based off an Access 2007 Database.

Here is the data validation I have on the begin_time field:

msxsl:string-compare(., ../preceding-sibling::dfs:myFields/dfs:dataFields/d:tbl_Timesheet/d:tbl_Entry[1]//dfs:myFields/dfs:dataFields/d:tbl_Timesheet/d:tbl_Entry/@end_time) <= 0

Thanks for your help.

Jeff

General

Re: time validation

Re: time validation

time validation