A number always with two digits as text (formula)

[Max]

Hello,
i get the day of a date in a formula with day().
i need this number allwas with 2 digits as a text (f.e. “05”)
i thought, i use ‘text(day(…),“00”)’ but it doesn’t work. I can’t find anything in the documatation.
Can anybody help me?

[rdb]

@Max

‘text(day(…),“00”)’

This is a bit too simple.

Try this:

if(
len(day({datecolumn}))=1,
“0”&day({datecolumn}),
day({datecolumn})
)

Then make sure that the result type is recognized as “string”.

[Max]

OK, I thought it would be simple
Thanks for this solution, it works
Simple formatting with the “text” command might be something for the future

[rdb]

@Max

Simple formatting with the “text” command might be something for the future

The purpose of text is different.