How do I show the date field as MM/dd/yyyy in flexmonster pivot table?

Answered
Mike Ngo asked on May 20, 2016

How do I show the date field as MM/dd/yyyy in flexmonster pivot table?  I keep getting the FLIGHT_DATE to show as a date hierarchy (FLIGHT_DATE.Day, FLIGHT_DATE.Month, FLIGHT_DATE.Year).
Here's a line in my JSON data for FLIGHT_DATE: {[FLIGHT_DATE, 02/03/2016]}
var reportQ3 = {
dataSourceType: "json",
data: jsonData2,
rows: [{
uniqueName: "POS_LEVEL5_CD",
hierarchy: "Geography",
type: "level",
parent: "Airline",
caption: "Continent"
}, {
uniqueName: "POS_LEVEL4_CD",
hierarchy: "Geography",
type: "level",
parent: "Continent",
caption: "Country"
}],
columns: [
{ uniqueName: "OPERATING_AIRLINE", caption: "Airline", type: "string", active: true },
{ uniqueName: "FLIGHT_DATE", caption: "Flight Date", type: "string", active: true },
{ uniqueName: "[Measures]", active: true }
]
}
 

2 answers

Public
Ian Sadovy Ian Sadovy Flexmonster May 20, 2016

Hello Mike,
 
Thank you for the question.
You can use "date string" type for such hierarchy, please check the following JSFiddle - https://jsfiddle.net/iansadovy/kvttpgLw/ 
Please let me know if it works for you.
 
Regards,
Ian

Public
Tanya Gryshko Tanya Gryshko Flexmonster December 7, 2016

Hello Mike and all Flexmonster users,
After the release of version 2.3, we would like to provide you with the updated sample: https://jsfiddle.net/flexmonster/uv1qop22/.
Regards,
Tanya

Please login or Register to Submit Answer