Hello Costas,
With some configuration, you can accomplish this. Using an automatic calculation, you can set the value of a Date/Time field (say 'Yes/No Last Modified') to the current date/time whenever the value of the Yes/No field is modified.
The 'Yes/No Last Modified' calculation should be Text. Assuming you are not defaulting the value of the Yes/No field to 1, it would look like:
Yes/No Last Modified =
$Case(
Yes/No == 0 && Yes/No Last Modified == "" , "" ,
Yes/No == 1 , $CurrentDateTime() ,
1 == 1 , $CurrentDateTime()
)
If you are defaulting the value of the Yes/No field, then you would use:
$Case(
Yes/No == 1 && Yes/No Last Modified == "" , "" ,
Yes/No == 0 , $CurrentDateTime() ,
1 == 1 , $CurrentDateTime()
)
Then a Match Criteria Alert can run daily, looking for records with 'Yes/No Last Modified' is in the last day.
Ryan
