i was planing to but because the if-then-else ‘‘Latest Re-test date’’ is showing the date as a text instead of date it messes up everything. I think I found the problem, because most of the things the app do involves generating documents with docs automator everytime I have a date/time column i use another column (Format Date) in order to format the date to be show correctly in the document. in this if-then-else column instead of passing trough the date column i used the date format column wich is seen as text. as soon as I changed it with date column the calculation was right.
Thank you all for your inputs. I apreciated
