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

stheapaut

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🌷🙂

stheapaut

Thank you for your answers :)

Quick Links

Can you help?

Unanswered questions

403 error trying to access Support Portal
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…