2 Replies Latest reply: Dec 23, 2012 9:47 PM by BCHK RSS

    Endeca Datetime Format

    BCHK
      Hi all,

      Anyone tried load SQL server datetime to Endeca property with type "datetime"?
      I tried but the property cannot get the data.

      One more thing, anyone has idea how to display the record according to the date of the product which match to system date
      and hence the "Product of the day" will be change every day automatically.

      Thanks.
      BCHK
        • 1. Re: Endeca Datetime Format
          Michael Peel-Oracle
          BCHK wrote:
          Hi all,

          Anyone tried load SQL server datetime to Endeca property with type "datetime"?
          I tried but the property cannot get the data.
          I think the date/time property format is intended to be either milliseconds since the midnight (for time), or Unix epoch time (for date/time). Personally I just reformat dates into YYYYMMDD and store them as Type=Integer, that way you can sort on them and they are human-readable.

          >
          One more thing, anyone has idea how to display the record according to the date of the product which match to system date
          and hence the "Product of the day" will be change every day automatically.

          Thanks.
          BCHK
          I'd set up a business rule sorted in descending order by my YYYYMMDD property and take the first one.

          Michael
          • 2. Re: Endeca Datetime Format
            BCHK
            Hi Michael,

            I have implemented in the same way as you.
            But I still wondering how to use the pipeline datetime format

            Thank you.
            BCHK