Approaches to populating the Status Change field
Label: Status Change
Field Type: Formula
Return Type: DateTime
//One statement per change (uses semi-colons)
If(And(${Contacts.Status}=='Active',${Contacts.Status Trigger}==0),Datepart(Now()); Replace(${Contacts.Status Trigger},0,1),)
If(And(${Contacts.Status}=='Inactive',${Contacts.Status Trigger}==1),Datepart(Now()); Replace(${Contacts.Status Trigger},1,0),)
//Two statements per change (does not use semi-colons)
If(And(${Contacts.Status}=='Active',${Contacts.Status Trigger}==0),Datepart(Now()),)
If(And(${Contacts.Status}=='Active',${Contacts.Status Trigger}==0),Replace(${Contacts.Status Trigger},0,1),)
If(And(${Contacts.Status}=='Inactive',${Contacts.Status Trigger}==1),Datepart(Now()),)
If(And(${Contacts.Status}=='Inactive',${Contacts.Status Trigger}==1),Replace(${Contacts.Status Trigger},1,0),)