Confiforms validation rule - Date field

[Andrzej]

Hello,

Can someone have a look on the below validation rule? Why is it not working as expected? 

I'm trying to create validation rule based on the another date field.

My criteria (as EmployeeContractEnd mustbe later then start date). I added dot in the validation rule. 

EmployeeContractEnd:>[entry.EmployeeContractStart] 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Andrzej 

You need to inverse the criteria, as you define WHEN this should fail... when the value in the EmployeeContractEnd is before the EmployeeContractStart

EmployeeContractEnd:<[entry.EmployeeContractStart] 

Trigger the error when value in the EmployeeContractEnd field is before the the date in the EmployeeContractStart field

Alex

[Andrzej]

I tried both but anyway I can successfully submit form with Contract End before start

<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="a9ae7c9c-c82d-4912-8ab4-736ef14d7b09" ac:name="tip" ac:schema-version="1">
<ac:rich-text-body>
<p>
<span style="color: rgb(0,128,0);">
<em>Kliknij przycisk <span style="color: rgb(51,102,255);">
<strong>
<ac:image ac:thumbnail="true" ac:width="100">
<ri:url ri:value="https://confluencedc.fortisbank.com.pl/download/thumbnails/438141139/image-2024-11-29_15-42-34.png?version=1&amp;modificationDate=1733401092440&amp;api=v2"/>
</ac:image> </strong>
</span>aby dodać nową procentową alokację pracownika, współpracownika lub wakatu. Wpisz słowo kluczowe w polu wyszukania  <ac:image ac:thumbnail="true" ac:width="80">
<ri:url ri:value="https://confluencedc.fortisbank.com.pl/download/thumbnails/438141139/image-2024-11-29_15-43-49.png?version=1&amp;modificationDate=1733401092473&amp;api=v2"/>
</ac:image>aby zweryfikować istniejące alokacje. Kliknij nagłówek kolumny aby posortować. Wybierz filtr przy nagłówku kolumny aby wybrać wiersze według wpisanych kryteriów. Kliknij podwójnie na komórkę aby rozpocząć edycję.   </em>
</span>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="350ddbc2-14d6-41c9-bb00-7e824736e2b9" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">CreateNewVacat</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">Create New Vacat </ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f1d942da-4d07-4fb8-8e3c-02b3325c7caa" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="css">height: 30px; </ac:parameter>
<ac:parameter ac:name="fieldPlaceholder">Indywidualne ID wakatu</ac:parameter>
<ac:parameter ac:name="fieldName">EmployeeID</ac:parameter>
<ac:parameter ac:name="fieldLabel">EmployeeID </ac:parameter>
<ac:parameter ac:name="values">2025VACAT:0</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="fieldDescription">Indywidualne ID wakatu</ac:parameter>
<ac:parameter ac:name="type">auto</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="a19a1fe0-1909-4605-befd-c0d830d5482f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="css">background-color: white; width:300px;</ac:parameter>
<ac:parameter ac:name="fieldName">EmployeeManager</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Manager</ac:parameter>
<ac:parameter ac:name="values">select DISTINCT [Employee Manager] as id, [Employee Manager] + ' (' + [Employee MPK] + ')' as 'Emploeyee Manager' from Employee </ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="fieldDescription">Wybranie managera z listy.</ac:parameter>
<ac:parameter ac:name="type">dbselect2</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="049b7516-8038-436b-930a-512c1c7ed148" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="css">background-color: white; width:300px;</ac:parameter>
<ac:parameter ac:name="fieldPlaceholder">wybór UOP / Kontraktor</ac:parameter>
<ac:parameter ac:name="fieldName">EmployeeContractType</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Contract Type</ac:parameter>
<ac:parameter ac:name="values">select DISTINCT [Employee Contract Type] from Employee</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="fieldDescription">Wybranie rodzaju umowy z listy.</ac:parameter>
<ac:parameter ac:name="type">dbselect2</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="81b0119e-a4f3-4b87-a45f-6679f40951f2" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="css">background-color: white; width:400px;</ac:parameter>
<ac:parameter ac:name="fieldPlaceholder">Wybieranie stanowiska z listy rozwijanej </ac:parameter>
<ac:parameter ac:name="fieldName">EmployeePosition</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Position</ac:parameter>
<ac:parameter ac:name="values">select DISTINCT [Employee Position] from Employee where [Employee MPK] like '55%'</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="fieldDescription">Wybieranie stanowiska z listy.</ac:parameter>
<ac:parameter ac:name="type">dbselect2</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="e3643164-2ab7-4982-ac02-2522be03f3fd" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="css">background-color: white; width:300px;</ac:parameter>
<ac:parameter ac:name="fieldName">EmployeeMPK</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee MPK</ac:parameter>
<ac:parameter ac:name="values">select DISTINCT [Employee MPK] from Employee where [Employee Area] like 'Obszar Nowych Technologii i Cyberbezpieczeństwa' ORDER BY [Employee MPK]</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="fieldDescription">Wybranie managera z listy.</ac:parameter>
<ac:parameter ac:name="type">dbselect2</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="7c16a4dd-87e9-466e-8dc7-7447fba48c45" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeContractStart</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Contract Start</ac:parameter>
<ac:parameter ac:name="validationMessage">Możesz wprowadzić datę przeszła tylko z bieżącego roku lub dowolną datę przyszłą.</ac:parameter>
<ac:parameter ac:name="fieldDescription">Data rozpoczęcia alokacji</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="b5280318-1a28-461b-9dc4-52a4469fed60" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeContractEnd</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Contract End</ac:parameter>
<ac:parameter ac:name="validationMessage">Możesz wprowadzić datę przeszła tylko z bieżącego roku lub dowolną datę przyszłą.</ac:parameter>
<ac:parameter ac:name="fieldDescription">Data zakończenia alokacji</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="81ab6b11-e60b-464b-97f2-24c089001917" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">[EmployeeContractEnd]:&lt;[entry.EmployeeContractStart] </ac:parameter>
<ac:parameter ac:name="noPropagation">true</ac:parameter>
<ac:parameter ac:name="values">.</ac:parameter>
<ac:parameter ac:name="action">Validation rule</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeContractEnd</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="8ebf1f7c-b5dd-4fc1-9807-e985b69070b3" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="mapping">result|summary|summary</ac:parameter>
<ac:parameter ac:name="fieldName">EmployeeType</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Type</ac:parameter>
<ac:parameter ac:name="values"> select ProductID, isnull([Product Name],ProductID) from Product where [Product Name] is not null and SourceID like '%Jira%' order by isnull([Product Name],ProductID)</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="extracontext">true</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="separator">issuetype = Product</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="f1dbd449-dcb5-4dcd-a24e-e0fee7c75c11" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeTime</ac:parameter>
<ac:parameter ac:name="fieldLabel">Employee Time</ac:parameter>
<ac:parameter ac:name="values">select DISTINCT [Employee Position] from EmployeeVacat</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="bb8f563e-d8bb-4d82-88a7-b7e21d03e79d" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="values">EmployeeType =VACAT</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeType</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="514a6116-868e-4968-8b1e-8dbafb945843" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeID</ac:parameter>
<ac:parameter ac:name="action">Hide field</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeID</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="7c8d84e5-c9ed-4058-9017-993443a9eb89" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeType</ac:parameter>
<ac:parameter ac:name="action">Hide field</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeType</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="9a79c5c4-ef15-40a4-88bc-38c63e7eb2b8" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">EmployeeTime</ac:parameter>
<ac:parameter ac:name="action">Hide field</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeTime</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="b6d245db-9205-4ec1-a764-efeb3b55bdd8" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="values">EmployeeTime =1</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeTime</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="078dcddb-0a44-4ccc-91e9-7f5d826716c2" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="condition">Status:success</ac:parameter>
<ac:parameter ac:name="action">Copy ConfiForms Data to DB</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">if not exists (select ev.EmployeeVacatID from EmployeeVacat ev where ev.EmployeeVacatID = cast([entry.id] as nvarchar(50))) begin insert into EmployeeVacat (EmployeeID, [Employee Manager], [Employee Contract Type], [Employee Position], [Employee MPK], [Employee Contract Start], [Employee Contract End], [Employee Type], [Employee Time], SourceID, [Update Time], [Update User], EmployeeVacatID) VALUES ( CAST(ISNULL([entry.EmployeeID], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeManager.id], 'NA') AS NVARCHAR(80)), CAST(ISNULL([entry.EmployeeContractType.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeePosition.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeMPK.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeContractStart.timestamp], '1900-01-01') AS DATE), CAST(ISNULL([entry.EmployeeContractEnd.timestamp], '1900-01-01') AS DATE), CAST(ISNULL([entry.EmployeeType], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeTime], 'NA') AS NVARCHAR(50)), 'confluencedc.fortisbank.com.pl', GETDATE(), CAST(SUBSTRING([entry.createdBy], 1, 50) AS NVARCHAR(50)), cast([entry.id] as nvarchar(50))) end</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="2b5e89e0-56bc-4fa7-8063-d142715cc1fb" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Copy ConfiForms Data to DB</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="event">onDeleted</ac:parameter>
<ac:parameter ac:name="title">delete from EmployeeVacat where EmployeeVacatID = cast([entry.id] as nvarchar(50))</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="ecca1c95-ecef-4d1a-845a-df19653d68e2" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Copy ConfiForms Data to DB</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="event">onModified</ac:parameter>
<ac:parameter ac:name="title">UPDATE EmployeeVacat SET [Employee Manager] = CAST(ISNULL([entry.EmployeeManager.id], 'NA') AS NVARCHAR(50)), [Employee Contract Type] = CAST(ISNULL([entry.EmployeeContractType.id], 'NA') AS NVARCHAR(50)), [Employee Position] = CAST(ISNULL([entry.EmployeePosition.id], 'NA') AS NVARCHAR(50)), [Employee MPK] = CAST(ISNULL([entry.EmployeeMPK.id], 'NA') AS NVARCHAR(50)), [Employee Contract Start] = CAST(ISNULL([entry.EmployeeContractStart.timestamp], '1900-01-01') AS DATE), [Employee Contract End] = CAST(ISNULL([entry.EmployeeContractEnd.timestamp], '1900-01-01') AS DATE), [Update Log] = cast(substring([entry.Comment],1,250) as nvarchar(250)) WHERE EmployeeVacatID = cast([entry.id] as nvarchar(50))</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="e7baac81-9ab0-4c30-988c-31e8b93dd5c2" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="condition">hasChanged(Status):true AND Status:success</ac:parameter>
<ac:parameter ac:name="action">Copy ConfiForms Data to DB</ac:parameter>
<ac:parameter ac:name="extras">d94b1e70e22146eb2f50b55278298f33</ac:parameter>
<ac:parameter ac:name="event">onModified</ac:parameter>
<ac:parameter ac:name="title">if not exists (select ev.EmployeeVacatID from EmployeeVacat ev where ev.EmployeeVacatID = cast([entry.id] as nvarchar(50))) begin insert into EmployeeVacat (EmployeeID, [Employee Manager], [Employee Contract Type], [Employee Position], [Employee MPK], [Employee Contract Start], [Employee Contract End], [Employee Type], [Employee Time], SourceID, [Update Time], [Update User], EmployeeVacatID) VALUES ( CAST(ISNULL([entry.EmployeeID], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeManager.id], 'NA') AS NVARCHAR(80)), CAST(ISNULL([entry.EmployeeContractType.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeePosition.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeMPK.id], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeContractStart.timestamp], '1900-01-01') AS DATE), CAST(ISNULL([entry.EmployeeContractEnd.timestamp], '1900-01-01') AS DATE), CAST(ISNULL([entry.EmployeeType], 'NA') AS NVARCHAR(50)), CAST(ISNULL([entry.EmployeeTime], 'NA') AS NVARCHAR(50)), 'confluencedc.fortisbank.com.pl', GETDATE(), CAST(SUBSTRING([entry.createdBy], 1, 50) AS NVARCHAR(50)), cast([entry.id] as nvarchar(50))) end</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="68af9e87-0346-4c18-8060-15a2be1a595f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">Status</ac:parameter>
<ac:parameter ac:name="fieldLabel">Status</ac:parameter>
<ac:parameter ac:name="values">false[success=APPROVED|moved=REVIEW|]</ac:parameter>
<ac:parameter ac:name="type">status</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="faed84b7-b5d3-43c7-a499-845c8ec10529" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Status:success AND !_user:POLACHOW*</ac:parameter>
<ac:parameter ac:name="fieldName">User does not have the rights to approve allocation. Please set 'Status' to REVIEW.</ac:parameter>
<ac:parameter ac:name="values">.</ac:parameter>
<ac:parameter ac:name="action">Validation rule</ac:parameter>
<ac:parameter ac:name="actionFieldName">Status</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="89ec451b-36d8-4220-8746-2ca0a53f4764" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">CreateNewVacat</ac:parameter>
<ac:parameter ac:name="registrationButtonLabel">Create New Vacat</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="71133bb1-f14a-4ae5-b570-b96b46db5e4a" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">!_user:POLACHOW</ac:parameter>
<ac:parameter ac:name="fieldName">User does not have the rights to delete record. Please contact with IT Organization team.</ac:parameter>
<ac:parameter ac:name="values">.</ac:parameter>
<ac:parameter ac:name="action">Validate on delete</ac:parameter>
<ac:parameter ac:name="actionFieldName">EmployeeName</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="4cfb797f-23f6-4855-9c7b-d5d75af9bac6" ac:name="table-filter" ac:schema-version="1">
<ac:parameter ac:name="inverse">false,false,false</ac:parameter>
<ac:parameter ac:name="ddSeparator">‚</ac:parameter>
<ac:parameter ac:name="sparkName">Sparkline</ac:parameter>
<ac:parameter ac:name="column">Employee Vendor,Employee Role</ac:parameter>
<ac:parameter ac:name="hidePane">Table header</ac:parameter>
<ac:parameter ac:name="isNew">false</ac:parameter>
<ac:parameter ac:name="separator">Point (.)</ac:parameter>
<ac:parameter ac:name="labels">Employee Vendor‚Employee Role‚</ac:parameter>
<ac:parameter ac:name="default">,,Employee Area&amp;&amp;Employee Name&amp;&amp;Employee Role&amp;&amp;Employee Status&amp;&amp;Employee Time&amp;&amp;Employee Type&amp;&amp;Employee Vendor</ac:parameter>
<ac:parameter ac:name="ddOperator">,</ac:parameter>
<ac:parameter ac:name="cell-width">150,150,150</ac:parameter>
<ac:parameter ac:name="hideColumns">true</ac:parameter>
<ac:parameter ac:name="datepattern">yy-mm-dd</ac:parameter>
<ac:parameter ac:name="hideFilters"/>
<ac:parameter ac:name="id">1733928193907_-666105136</ac:parameter>
<ac:parameter ac:name="isOR">AND</ac:parameter>
<ac:parameter ac:name="formatVersion">2</ac:parameter>
<ac:parameter ac:name="order">0,1,2</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="937e0961-c59f-4d96-9551-554753d30cbb" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="enhanceFreeTextSearch">true</ac:parameter>
<ac:parameter ac:name="pager">10</ac:parameter>
<ac:parameter ac:name="formName">CreateNewVacat</ac:parameter>
<ac:parameter ac:name="sort">AllocationStart desc</ac:parameter>
<ac:parameter ac:name="enableGridEdit">true</ac:parameter>
<ac:parameter ac:name="enableSearch">true</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="b981f6f8-31f9-4873-bac0-f7dca84f2e69" ac:name="confiform-entry-edit" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>

[Andrzej]

just one more validation question. Why the same dates are being processed in this case? 
How can I adjust it. I tried something like

EmployeeContractEnd:<[entry.EmployeeContractStart] OR EmployeeContractEnd: [entry.EmployeeContractEnd] = [entry.EmployeeContractStart]

EmployeeContractEnd:<[entry.EmployeeContractStart] OR [entry.EmployeeContractEnd] = [entry.EmployeeContractStart]

EmployeeContractEnd:<[entry.EmployeeContractStart] && [entry.EmployeeContractEnd] != [entry.EmployeeContractStart]

[Alex Medved _ConfiForms_]

EmployeeContractEnd:<=[entry.EmployeeContractStart]

https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters 

[Andrzej]

so it's works now. But let say the contract end field is not obligatory but right now I can't submit the form without filling this field Employee Contract End. Do you know any way to get around it?

[Alex Medved _ConfiForms_]

!EmployeeContractEnd:[empty] AND EmployeeContractEnd:<=[entry.EmployeeContractStart]

[Andrzej]

thank you