Schedule "Generate Changes" for an Adapter in Identity Broker

The issue is that the record never changes they have a furure start date and i cacl if the record is active using the start date. it is an csv connector.  

This sounds exactly like the use case for the Time Offset Flag transformation. If you set the Offset Field to the field containing your start date, the Destination Field to your new field (e.g. HasStarted), the Time Offset to 0 (or perhaps a few hours to get it to 9am or a desired specific start time), and the four flags as appropriate (e.g. Equal and Greater as True, Lesser and Null as False), you should get the desired behaviour.

Hi,

Back from leave and can share more about the solution. we are using more than one attribute to cacl the status of the record and powershell seemed to be the only option. see script below:

# Loop through each input entity
# Using TerminationDate & CompletionDate to generate isActive false or true
$datenow =  (get-date).Date
foreach ($entity in $entities)
{
    if($entity['TerminationDate']){
    
        #$date = (get-date $entity['TerminationDate']).Date
        $date = $entity['TerminationDate']
        if($datenow -eq $date){
            $entity['isActive'] = 'false'
        }
        elseif($datenow -gt $date){
            $entity['isActive'] = 'false'
        }
        else{
            $entity['isActive'] = 'true'
        }
        
    }
    elseif($entity['CompletionDate']){
        #$date = (get-date $entity['CompletionDate']).Date
        $date = $entity['CompletionDate']
        if($datenow -eq $date){
            $entity['isActive'] = 'false'
        }
        elseif($datenow -gt $date){
            $entity['isActive'] = 'false'
        }
        else{
            $entity['isActive'] = 'true'
        }
    }
    else{
        if($entity['ProposedStartingDate']){
            $date = $entity['ProposedStartingDate']
            if($datenow -eq $date){
                $entity['isActive'] = 'true'
            }
            elseif($datenow -gt $date){
                $entity['isActive'] = 'true'
            }
            else{
                $entity['isActive'] = 'false'
            }   
        }
        else{
            $entity['isActive'] = 'false'
        }
    }
    
}

Hi Alan,

An alternative implementation might be to use Time Offset Flag transformations to generate IsTerminated, IsCompleted and HasStarted flags, and then use the PowerShell transformation only to perform the necessary boolean logic. In this case, change detection would occur automatically as part of the Time Offset Flag transformations.

Ok that makes sense

Don't know if there is an better transformation but for now i will implement the scheduled job to run once a day.

Is there more detail in how to use the powershell vars and methods!?