Auto selecting other column based on selection

[Anonymous]

Hey buddies,I have two date columns one has Invoice date and other column has Paid date.If I select the invoice date then automatically the closest paid date to that invoice date should get selected.How to implement this.

As shown In the above picture.If I select Notified date 5/14/2014 then closest date in Paid date box 06/27/2014 should get selected.

[#2]

question -  closest paid date be greater than, less than the notified date?

what if there is a date that is the same number of days away where one is higher and one is lower?  which one should be chosen?

what is the use case?  are both dates associated to the transaction in your data model?

what happens if user selects the paid date

[Anonymous]

Paid date will be always greater than Notified date.

If there is a date same number of days away then auto selection should be on lower date in paid date column.

[#4]

so there will not be a scenario where the closes paid date would be less than the notified date

[Anonymous]

Yeah,Customer will get payment notification after the invoice gets generated.So assuming there is no issue with data entry,Paid date should come only after the invoice date.