Using Tester Transformer to query Yesterday (Datetime field)

Question

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.

Answer 1 · 2017-10-04T20:42:38Z

Best Answer

Answer by lenaatsafe · Oct 04, 2017 at 08:42 PM

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)

Add comment · Share

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

Answer 2 · 2017-10-04T22:22:05Z

Answer by schatt15 · Oct 04, 2017 at 10:22 PM

@LenaAtSafe, thank you. That worked.

Add comment · Share

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

Using Tester Transformer to query Yesterday (Datetime field)

2 Replies

Follow this Question

Related Questions