BCHK wrote: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.
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 dateI'd set up a business rule sorted in descending order by my YYYYMMDD property and take the first one.
and hence the "Product of the day" will be change every day automatically.