Exporting Time Periods differences for different layout

I know it's written on Anapedia:
https://help.anaplan.com/export-layouts-and-time-period-labels-a274b42d-c982-4c87-9c70-626f1c446c60

Date format for Grid export layout is MMM YY while Tabular Single Column is YYYY-MM.

But why?

Answers

  • Hello,

    Because, this helps in filtering data in columns. YYYY-MM format data can be filtered easily. In Grid view, time will be considered as Headers. Hence, time format is MMM YY

    Thanks,

    Ravi

  • Thanks - it gives some insight to why. In terms of filtering on Excel after export, I would imagine both can be filtered easily.

    Moreover, if Anaplan can choose what date format we are importing from a .csv file, why can't we choose what date format we are exporting to a .csv file? Or even specify something as date formats before we export?