1 Reply Latest reply on Sep 18, 2012 8:47 AM by Michael Peel-Oracle

    Getting Current Date on Endeca Pipeline

    952104
      Hi,

      I would like to compare the a some other date(which is property) with the current date like

      <EXPRESSION LABEL="" NAME="IF" TYPE="VOID" URL="">
      <EXPRESSION LABEL="" NAME="MATH" TYPE="INTEGER" URL="">
      <EXPRNODE NAME="TYPE" VALUE="STRING"/>
      <EXPRNODE NAME="OPERATOR" VALUE="EQUAL"/>
      <EXPRESSION LABEL="" NAME="IDENTITY" TYPE="PROPERTY" URL="">
      <EXPRNODE NAME="PROP_NAME" VALUE="*SomeOtherDate*"/>
      </EXPRESSION>
      <EXPRESSION LABEL="" NAME="CONST" TYPE="STRING" URL="">
      <EXPRNODE NAME="VALUE" VALUE="*CurrentDate*"/>
      </EXPRESSION>
      </EXPRESSION>

      How do I get or refer the current system date on pipeline.

      And also need info on how to compare the dates.


      Thanks,
      Bharath

      Edited by: 949101 on Sep 17, 2012 11:17 PM

      Edited by: 949101 on Sep 17, 2012 11:56 PM
        • 1. Re: Getting Current Date on Endeca Pipeline
          Michael Peel-Oracle
          I'd do this upstream of Endeca (in your data extract process), or if that isn't an option then use a perl manipulator: http://docs.oracle.com/cd/E28912_01/DeveloperStudio.612/pdf/ForgeAPIGuidePerl.pdf .

          In terms of comparison, a handy method is to format dates as YYYYMMDD - you can then use X > Y, X < Y, sort them in ascending/descending, etc.