Date Format with zero 0

Right now in a Table View a Date column is like โ€œ1.1.2019โ€.
How can I change it to โ€œ01.01.2019โ€ ?

Solved Solved
0 2 461
  • UX
1 ACCEPTED SOLUTION

@Fabian
Actually you canโ€™t format the display. But, you can create a VC with an expression like:

CONCANTENATE(RIGHT("0" & DAY([DATE]),2),".",RIGHT("0" & MONTH([DATE]),2),".",YEAR([DATE]))

and use this VC in your Table View.

View solution in original post

2 REPLIES 2

@Fabian
Actually you canโ€™t format the display. But, you can create a VC with an expression like:

CONCANTENATE(RIGHT("0" & DAY([DATE]),2),".",RIGHT("0" & MONTH([DATE]),2),".",YEAR([DATE]))

and use this VC in your Table View.

Thank you that solved the problem.

Top Labels in this Space