Skip to main content

Hi, the purpose is to have the possibility to add dates rows in a repeating table. Each date can`t be more then 365 days from current date. I should include the function currentRowNumber in the formula. But i dont know how.

 

This is, what i already have:

17731i4157E31B3507999B.png

I can add date to repeating table. In the first colummn is a calculated value of days, second colummn is the number of row.

 

Now, i need to add a Validation Rule. If the value(dayscount) in concrete row is greather then 365, show an error message. My problem is, i don`t know how to write down the condicion/formula into the rule. Also i don`t known if I have to add the rule to the repeating table or to date/time form control.

Can somebody help me please?

Thanks

DJ

@DusanJ  apply below steps:



 





  • Add always hidden calculated control in your repeating section, name it "calc_ctrl_datediff" and add below formula:



    • dateDiffDays(dt_ctrl_date, Current Date) 




      • dt_ctrl_date ----> is the name of your date control in your repeating section






    • Apply a validation rule on dt_ctrl_date:



      • greaterThan(calc_ctrl_datediff, '365')






    • You DO NOT need row count for this








 


Thanks very much. I will try it and give feedback.
Thanks, it works.)

Reply