Convert a number to Date

melliott

Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?

Accepted answers

All comments

Panji

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

MarkWarren

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).

M.Kierepka

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:

Quick Links

Can you help?

Unanswered questions

Call Center Indodax
Hubungi Call Center INDODAX melalui +62822225789 WA atau email support@indodax.com.
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…