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:
XL3SetProperty to navigate
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
