Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2013-10-01T10:07:06Z by fredrix17
SystemAdmin
SystemAdmin
197 Posts
ACCEPTED ANSWER

Pinned topic How do I display the Date facet as yyyy-MM-dd hh:mm:ss?

‏2013-02-20T15:14:08Z |
In the built-in enterprise search application, the Date facet appears as MM/dd/yy (even though my locale specifies dd/MM/yyyy). How can I make Date display as yyyy-MM-dd hh:mm:ss?

Why don't I see the Date facet in the Parse and Index pane's Facets?
Sometimes the Date facet appears as a Java Date in milliseconds. Can I make it appear as yyyy-MM-dd hh:mm:ss instead?

Thanks,
Eli
Updated on 2013-03-20T16:49:03Z at 2013-03-20T16:49:03Z by SystemAdmin
  • mauriziog
    mauriziog
    5 Posts
    ACCEPTED ANSWER

    Re: How do I display the Date facet as yyyy-MM-dd hh:mm:ss?

    ‏2013-03-06T14:29:58Z  in response to SystemAdmin
    To change/customize date format, in the ICA admin console, Parser & Indexer section: Configure parser & indexer for this collection (Edit) -> More -> Custom date format.

    To see the date facet, try the following that works for analytics collection, but I don't know if it will work for search collections:
    in the ICA admin console, find the Action button over the Search section: Action -> Settings -> Edit collection settings;
    you should see all available date fields in "Fields used as a date facet in the content analytics miner";
    check the ones you want to use.

    Whether a specific date appears in epoch time, you have to:
    locate ....../esdata/master_config/searchapp/search/config.properties
    and add the date fields not mentioned in the following section
    #==============================================================================================
    1. The following fields are date fields (they will be formatted as a date)
    #==============================================================================================
    date.fields=modifieddate createddate date atompublished atomupdated creationdate

    This is the link to the ICA InfoCenter document about the matter
    http://pic.dhe.ibm.com/infocenter/analytic/v3r0m0/topic/com.ibm.discovery.es.ad.doc/iiysadates.htm

    hope this help
    • SystemAdmin
      SystemAdmin
      197 Posts
      ACCEPTED ANSWER

      Re: How do I display the Date facet as yyyy-MM-dd hh:mm:ss?

      ‏2013-03-20T16:49:03Z  in response to mauriziog
      Thanks! Yes, ICA was using my FF language setting, which was EN/US, so it displayed MM/dd.
      When I told FF to use EN/GB, ICA correctly displayed dd/MM.

      But what I'd really like is dd/MM/yyyy hh:mm, not dd/MM/yy.

      Custom Date Format seems to be for parsing document dates, not for displaying dates.

      My problem isn't which dates to display, but rather the format in which to display them; I want dd/MM/yyyy hh:mm

      Thanks,
      Eli
      • fredrix17
        fredrix17
        21 Posts
        ACCEPTED ANSWER

        Re: How do I display the Date facet as yyyy-MM-dd hh:mm:ss?

        ‏2013-10-01T10:07:06Z  in response to SystemAdmin

        Hi! Eli, did you find a solution for your question? 

        I have the same task to display time with date .

        Thanks for any help.

        Updated on 2013-10-02T07:31:31Z at 2013-10-02T07:31:31Z by fredrix17