Improve time period imports for CSVs

Nicolas Cadier

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.

CallumW

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.

Miran

Status changed to: New

obriegr

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

I made this suggestions several days before yourself.

LINK