This discussion is archived
1 Reply Latest reply: Sep 18, 2012 1:47 AM by Michael Peel RSS

Getting Current Date on Endeca Pipeline

952104 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points