Next Counting Period

sunnyk

Hi All,
How to capture the dates from Next counting Period Field of Item. Since its a text type field, so i used Evalute function to get the two dates(either side of range ..). But how to avoid the date format issue? Suppose if in the Next counting period we have value in dd/mm/yy format and if i change my date setting to mm/dd/yy, it will throw an error. How to avoid this.

einsTeIn.NET

Try to apply the whole field as a filter to a date field and then get the beginning by GETRANGEMIN and the end by GETRANGEMAX.