Hi, in my repeating section, I have date and amount. Because I can't connect fields in repeating section to a column to extract data, I am doing a calculated value outside of the repeating section to get the total of the amount. However, how can I extract the latest date using calculated value? Whats the formula? I tried using max and it gives me a series of number instead of mmddyyyy.
Please note that my date field is a single line text box, I can't use a date field for date because calculated value can't be connected to a date field. This is my workaround to extract data from the repeating section.
Thanks
