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

Selective Access user lookup?
@rob_marshall I feel like you would be able to answer my question, and if you can't then no one can. My question is - using selective access on a hierarchy level I want to be able to look up the user that has access to a particular level within the hierarchy so that I can create a standardized e-mail using the mailto…
Time Filter on Custom view in My Pages
I have difficulty with “Custom views” in Activities 13.6.5 and 13.9.3 where I select Custom View but cannot Filter Time Dimension. The instruction is "Filter: Time - show only Forecast Months" Could anyone please help on this issue.
Forecaster missing Error Messages and Stuck on Creation
Hi! I'm currently trying to set up an example for the forecaster and I'm running into various issues. At first (and I managed to resolve it by now) my data collection creation failed without any error messages. Next, after I managed to create it, my forecaster model is stuck on status 'creating' for 1.5 hours already. Is…