ChrisDobberfuhl
6 years agoQrew Member
Counting Date/time field changes
Is it possible to create a formula that will keep a running count of how often a date and time field changes? I make daily uploads tracking hardware login information and I am attempting to track a fields times its updated. I found an old formula that will supposedly track a text field change ( I will post bellow) but the text field may not change for some of my users. In addition this formula does not seem to actually increase in values.
var text value = [Last Login User];
Count(
Part($value,1,"]"),
Part($value,2,"]"),
Part($value,3,"]"),
Part($value,4,"]"),
Part($value,5,"]"),
Part($value,6,"]"),
Part($value,7,"]"),
Part($value,8,"]"),
Part($value,9,"]"),
Part($value,10,"]"),
Part($value,11,"]"),
Part($value,12,"]"),
)
------------------------------
Chris Dobberfuhl
------------------------------