nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to convert a date into 2digit format text DD/MM/YYYY

stt

Hi,

I'm trying to convert a date into a text line item but Month and Day sometimes have only 1 digit when I need two.

Do you know how I can achieve that ?

Accepted answers

seymatas1

Hi @stheapaut,

Month and Day sometimes have only 1 digit when I need two

Use RIGHT() function to solve that.

I hope this helps.

Seyma🌷🙂

All comments

AjayM

Hi,

I guess you know that converting date to number is the first step. Next, when you convert from number to text, you would want to apply a conditional statement like if day number <10, then append zero to the text result, and similarly if month number < 10 then append zero.

Cheers!

seymatas1

Hi @stheapaut,

Month and Day sometimes have only 1 digit when I need two

Use RIGHT() function to solve that.

I hope this helps.

Seyma🌷🙂

stt

Thank you for your answers :)

Quick Links

Can you help?

Unanswered questions

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…