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?
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.
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:
defaultDateType parameter is used to specify which data types should be applied to date fields by default (
datetime) for CSV and JSON data sources.
Please let us know if this works and if you have further questions.