I just want to share a simple table as a summary of the functions needed to convert data across formats in Anaplan.
Is not a big deal, but I hope it comes in handy to some of you.
* Transform Text into Date is not that straight forward since it is needed to chop the date in 3 chunks: the day (DD), the month (MM) and the year (YYYY), use VALUE to turn them into numbers and then use the function DATE to fetch the date.
Is it worth adding that changing a date to text format requires a DAY, MONTH, YEAR function, (split into separate line items for best practice) and then a TEXT function on each line item to piece the date back together?
I might add a suggestion to get a function added to simplify this process.
All of the above is the reason why it is so important to bring dates in as date formats in the first place. Not only do text formats take up more space and memory, but it is so much extra work to do to re-format.
Try and unify on the format for all imports (e.g. YYYYMMDD) and use that for all dates to avoid this issue.
Even for user driven uploads, it is better to add another column/row in the file to format the date in a "friendly" format