srjnchandra599
Design Dabbler

Date comparison in repeating section Office 365

Using responsive designer, is there a way that we can compare two date fields in Nintex Office365? Requirement is that the first date should be less than second date and second date should be less than third date and so forth..

0 Kudos
Reply
6 Replies
leighburke
Nintex Employee
Nintex Employee

Re: Date comparison in repeating section Office 365

@srjnchandra599  You should be able just use a submit rule like below. We do also have some date functions(https://help.nintex.com/en-US/office365/Designer/FormulaBuilder.htm) you can use in a formula if needed as well.

 

leighburke_0-1601358565345.png

 

0 Kudos
Reply
srjnchandra599
Design Dabbler

Re: Date comparison in repeating section Office 365

Hi Leighburke,

Thanks for the reply. I have added rules for repeating section, but it doesn't work. I need to compare the latest 2 dates and find out the difference. The first date should be involved in this comparison.

 

Thanks

0 Kudos
Reply
leighburke
Nintex Employee
Nintex Employee

Re: Date comparison in repeating section Office 365

@srjnchandra599 Sorry I missed the repeating section in the heading. Are you trying to compare each row within itself or just the last row?

0 Kudos
Reply
srjnchandra599
Design Dabbler

Re: Date comparison in repeating section Office 365

First row date should be less than second row date and second row date should be less than third row date, and so on.

srjnchandra599_0-1601420590545.png

 

0 Kudos
Reply
leighburke
Nintex Employee
Nintex Employee

Re: Date comparison in repeating section Office 365

@srjnchandra599 There isn't really an easy way to do this as repeating section data lives in an array and there isn't a way to reference the row in an array currently. Do you have an idea of how many max you are expecting?

0 Kudos
Reply
srjnchandra599
Design Dabbler

Re: Date comparison in repeating section Office 365

For now max dates I can think is around 15 to 30. Again, if we can able to figure out a way to compare only the last 2 dates then we should be good.

0 Kudos
Reply