Skip to main content
  • EN

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.

Reply


Community Stats

30,187
Posts
114,582
Replies
37,853
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.