Hi
I have a repeating table, that contains 3 columns, one is a Drop-Down List Box, and two are DatePickers that contains StartDate and EndDate.
I have two fields StartDateOnlyDay and EndDateOnlyDay that stores only the day from the DatePicker. (i.e. StartDate is 8/16/2016 then StartDateOnlyDay is 16).
When I insert a new item on the repeating table, fields StartDateOnlyDay and EndDateOnlyDay doesn't update, I mean that fields StartDateOnlyDay and EndDateOnlyDay contains each time days from the first row.
The formula for StartDateOnlyDay and EndDateOnlyDay is "number(substring(Start_date1, 9, 2))", "number(substring(End_date1, 9, 2))".
How can I resolve that?
Thank you,
Ionela