1

Honesty I'm very new in terms of Scribe Jobs, but I have been trying to develop a Job that get the current date and compare it against one field from the source (CRM input Date).

This is the code in the formula editor of the Pre-Operation Step Control:

IF(S146 =TODAY( ), GOTOSTEP ( ),FAILROW( ))

I'm trying to allow the migration only for records inserted today, the rest will just generate error.

Can somebody help me?

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
user6267607
  • 11
  • 2

1 Answers1

-1

Try this:

if( DATEDIFF ("d", GETCURRENTUTCTIME, S146) < 1 )

Here's a great place to look for more information: http://help.scribesoft.com/scribeonline/en/sol/formulas/datefunctions.htm

Gustavo Morales
  • 2,614
  • 9
  • 29
  • 37
Elmer
  • 139
  • 1
  • 4