Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
Hi @melliott ,
First you need convert number to text
second you need to break data to day, month, and year
third you need to convert data (day, month, year) to DATE
Here the Blueprint
Regards,
Panji
How does this number come in to Anaplan?If it is imported in you could convert to date during import (assuming it comes with a leading zero, 04112022).
Hi @melliott,
I assume it's always imported as an 8-digit number, with all leading zeros included (so it's unambiguous that i.e. 1112022 is 1/11/2022, and 11/1/2022 would be 11012022). Also in my answer I assume format MMDDYYYY, and I do conversion just on numbers (without converting back and forth to text):
Blueprint:
Hi All, I'm Currently Optimising some of our Cell-Count Intensive Reporting Modules, I've an almost working solution except for this limitation I'm facing. We've around 5-6 Reporting modules in our model which is Dimensioned by Levels of Promo Hierarchy X Users, promo Customer Hierarchy X users. Since the promo customer…
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
