Improve time period imports for CSVs

Improve time period imports for CSVs

The standard excel format for Month-Year is MMM-YY.

I.e. if a user types Jan 20, excel will convert this to a numeric value and display Jan-20.

Anaplan does not recognise this as a valid time period when importing.

As this is the default excel format, it would be great if Anaplan could recongise this correctly. Rather than having to edit the format for each import file.

Super Contributor

Whilst you can define this manually as "mmm-yy" in the "Custom fixed-position pattern", I agree it would be useful if Anaplan auto recognised this common format.

Super Contributor
Status changed to: Your support is needed
Certified Master Anaplanner

This is also true in any text formatted and various delimited files.

I made this suggestions several days before yourself.