After initial data sync with SQL Server as source, we are trying to use an import job to pick up delta (new/changed) data. We are comparing the dateUpdated column (datetime datatype in sql server tables) with LAST_RUN. It didnt pick up 4-5 hours of modified data as the Timezone is EST is behind UTC. We informed the client of this requirement but as this database is managed by an ERP system and their business processes need the data to be in EST timezone, they have refused to change the timezone. So now we are trying to adjust the dateUpdated value to UTC and then comparing with LAST_RUN value. But the filter criteria dialog it only allows selecting LAST_RUN on one side and the dateUpdated column on the other side but doesnt allow editing it or using it in an expression. Even Informatica cloud provides Filter-expression where one can enter an expression with a column for the same situation. See this link: https://www.mydatahack.com/informatica-cloud-incremental-load-with-data-synchronisation/
Surely this must be a common situation as LAST_RUN is fixed at UTC , if that cant be changed, then just changing the other side of the equation will do it. But where is the option for that ?
Please indicate how this can be done or how OTHER USERS have dealt with this situation as everybody cannot have timezone as UTC. Just this small part not working is preventing us from using Skyvia successfully.