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 457
  • 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