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.

3 Comments
Master Anaplanner/Community Boss

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.

Community Manager
 
Status changed to: Needs Community Support
Certified Master Anaplanner

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

I made this suggestions several days before yourself.

LINK

Users Online
Currently online: 223 members 988 guests
Please welcome our newest community members: