Convert a number to Date
Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
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).1
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):