Exporting Time Periods differences for different layout

Options
matthewman
matthewman
in Modeling

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

  • yraviteja
    yraviteja
    Options

    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

  • matthewman
    matthewman
    Options

    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?

  • SriNitya
    SriNitya
    Options

    @mathewman Currently in Anaplan we don't have any date format selection for exports.

  • 1636583
    1636583
    Options

    choosing date format before export would be a good modeling enhancement suggestion to the community @matthewman , and again it depends on our system time related settings how it looks in excel after export, I think 🤔.

Categories