Re: Date format differs while exporting a file in different type of system (eg.MS Excel and Open off
The name matching has to be in the format "MMM YY", so in Excel you'd need to set that as a custom formatting. There can be some differences between systems in how they format dates but most systems will allow for a numeric date output which is more commonly recognized. Just a minor thing that Excel has decided to put in a hyphen in their format of "MMM-YY". Unfortunately Anaplan doesn't allow for a custom name format here, so has to be done at source.