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.
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
Hi Vera,
This worked.
Thank you!