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.
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.
This is also true in any text formatted and various delimited files.I made this suggestions several days before yourself.LINK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.