This discussion is archived
2 Replies Latest reply: Dec 23, 2012 7:47 PM by BCHK RSS

Endeca Datetime Format

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

Legend

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