Posts

Showing posts from October, 2016

Custom Sitecore Intel Transformers To Modify Date Format In Experience Profile

Image
Going through the recently published Sitecore StackExchange site, I came across a question regarding modifying the date format of visits in Experience Profile since it shows the dd.mm.yyyy format by default. In case you don't know what I am talking about, here is what it looks like:



It's not just that one view, the default date format seems to apply to other views as well:



My obvious thought here was that there has to be a config setting somewhere that controls this date format. Here is my process of elimination:
Eliminated Experience Profile configs since it did not contain any date related settingsLooked at showconfig.aspx and found some index fields that contained date formats but eliminated since the default format was yyyy/mm/ddEliminated the Reporting Database since the data formats were differentLooked at the service calls made by Experience Explorer to fetch view data and found this: "InteractionStartDateTime":"2016-10-20T15:34:20.449" "Forma…