asked on September 10, 2019
I have a date filed in my JSON data source. But in the FM pivot it is spited to Year, day, Month.
But I want to show whole date complete date in date format in columns or rows.
How to do that?
⋅ September 10, 2019
Please find the attachment for reference. I want to drag the full SystemEntry date to rows. Customer wants to see the Date column not the year, month, day as separate columns or rows.
⋅ September 10, 2019
Hello, Kranthi,
Thank you for your question.
Here are two ways you can achieve the desired output:
1. By specifying the needed date data type in the JSON meta-object.
For your case, we kindly suggest using the date string date data type.
Please see our data types in JSON guide for more details.
2. By specifying the defaultDateType parameter in the options object:
The defaultDateType parameter is used to specify which data types should be applied to date fields by default (date, date string, year/month/day, year/quarter/month/day or datetime) for CSV and JSON data sources.
Please let us know if this works and if you have further questions.
Best Regards,
Vera
⋅ September 11, 2019
Hi Vera,
This worked.
Thank you!
