I am using the following workflow to pass and INSERT in writer all records with datetime "yesterday". Rest all records will be UPDATE based on an ID field. This workflow will be scheduled to run everyday. I am sure my value field to calculate yesterday is not correct! Any guidance will be helpful.
Hi @schatt15
if Lst_Updt_Dt_Tester is the date (or datetime) that needs to be yesterday, the Tester/TestFilter condition should be:
@DateTimeFormat(Lst_Updt_Dt_Tester,%Y%m%d) = @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P1D),%Y%m%d)@LenaAtSafe, thank you. That worked.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.