Daily Date Format

Hi,

I have a module with a time range as a dimension.

I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's 2000-onwards), so because it is a text, it doesn't consider that region setting from either excel or windows, and it translates it into 1/1/1937 which is wrong.

I did include a line item to show the date but it's not a solution to my problem, and it actually doesn't align with the way the model or the specific module is set up, as I want the dimension to have MMDDYYYY format (or whatever date format but with YYYY) and do not want an additional line item.

If anyone has a solution to this problem, that'd be really helpful

Thanks

Accepted answers

All comments

Quick Links

Can you help?

Unanswered questions

Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Dynamic Export Reporting
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.