Skip to main content
Question

Using Tester Transformer to query Yesterday (Datetime field)

S
Forum|alt.badge.img

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.

2 replies

L
Forum|alt.badge.img

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)
S
Forum|alt.badge.img
  • schatt15
  • Author
  • October 4, 2017

@LenaAtSafe, thank you. That worked.

Reply


Helpful Members This Week

Community Stats

31,378
Posts
119,007
Replies
39,007
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.