General

Re: Compare dates in repeating table

Dmitriy — Thu, 14 Mar 2013 09:27:00 GMT

Thanks a lot! Works fine now)

Re: Compare dates in repeating table

Hilary Stoupa — Wed, 13 Mar 2013 17:48:23 GMT

My question was about your main data source. Your original screenshot showed only the form layout, which tells me nothing about the XPath for the nodes. But, that said, taking another look - the button is outside of the repeating section and thus that condition would by default be only considering the first row. I'm attaching a sample form - save it locally and then right click and select design to open in design mode.

I'm guessing your XPath expression will need to be:

/my:RateOverride/my:Rates[msxsl:string-compare(my:StartDate, my:EndDate) >= 0]

EDITED TO ADD: I clicked on your original screenshot and see the main data source now - sorry about that! It wasn't displaying until I opened the picture itself.

Re: Compare dates in repeating table

Dmitriy — Wed, 13 Mar 2013 17:33:18 GMT

I attached screenshot.... Repeating group - Rates. Datasource - xml, that filling in via managed code.Yes. Condition is on the button.

if it so important what datasource I use for ddls:
<?xml version="1.0" encoding="UTF-8" ?>
<items>
<item><value/><displayname/></item>
<item><value/><displayname/></item>
</items>

just use it for databinding ddl with WCF... thats it. Does it affect on date validation in repeating table?Still need to validate StartDate<EndDate in whole repeating table.. not only in the 1st row. Thanks

Re: Compare dates in repeating table

Hilary Stoupa — Tue, 12 Mar 2013 15:08:05 GMT

Mind showing what the actual data source is? What is the repeating group? I'm guessing the condition is on the button?

Re: Compare dates in repeating table

Dmitriy — Tue, 12 Mar 2013 08:04:48 GMT

I have secondary datasources(2 xml) and i work with them in codebehind via wcf (https) to fill in drop down lists on the form. So what I need is to disable button in case when in any row of repeating table start date > end date. Problem is that msxsl:string-compare(/my:RateOverride/my:Rates/my:StartDate, /my:RateOverride/my:Rates/my:EndDate) >= 0 works just for the 1st row and doesn't work for other rows.

Re: Compare dates in repeating table

Hilary Stoupa — Mon, 11 Mar 2013 14:50:52 GMT

What is the field the condition is on? Can you attach a screenshot of the data source under the Options tab? Or just attach your form?

Re: Compare dates in repeating table

Dmitriy — Mon, 11 Mar 2013 09:34:48 GMT

Help plz, still need help

Compare dates in repeating table

Dmitriy — Thu, 28 Feb 2013 15:59:45 GMT

I can't to compare 2 dates in repeating table. This rule msxsl:string-compare(/my:RateOverride/my:Rates/my:StartDate, /my:RateOverride/my:Rates/my:EndDate) >= 0 works just for the 1st row. Could you help me, please?