I feel i should know this…is it possible to do a search for things calculating the difference between the modified date and created date (as seconds) . Then creating a grand total of all the results returned for all things as seconds?
how are you trying to achieve this, via backend workflows or on page? If on page is that via workflows or in a repeating group?
Also, is there a need to determine first the list of entries whose created date is different from modified date?
Do a search for Thing:formatted as text:split by #:each item converted to number:sum
Inside format as text:
This Thing’s Modified date - This Thing’s Created date:formatted as seconds with delimiter of # (using comma will break it if other languages are used as decimal places can become commas)
1 Like