Make Date Submitted 2 Digits on Table

[CaptNemo]

How can I make the dates submitted on my table 2 digits using the formula field? Here is a screenshot of the result I wanted.

[CoopperBackpack]

Hello @CaptNemo,

As far as I understood you want to add a leading zero to the numbers less than 10.

If so, please test these formulas:

- Hours 

RIGHT('0' + CAST((DatePart(hour, [@field:Date_field])) as nvarchar), 2)

- Minutes

RIGHT('0' + CAST((DatePart(minute, [@field:Date_field])) as nvarchar), 2)

Where [@field:Date_field] should be replaced with your field name.

[Winskey]

Hi @CaptNemo,

Here is a formula that you may use to add a leading zero to the numbers less than 10:

-Hours
 

CASE 
  WHEN DATEPART(hh, [@field:Date_Field]) < 10 
  THEN '0' + CAST(DATEPART(hh, [@field:Date_Field]) AS VARCHAR)
  ELSE CAST(DATEPART(hh, [@field:Date_Field]) AS VARCHAR)
END

-Minutes

 

CASE 
WHEN DATEPART(n, [@field:Date_Field]) < 10 
THEN '0' + CAST(DATEPART(n, [@field:Date_Field]) AS VARCHAR) 
ELSE CAST(DATEPART(n, [@field:Date_Field]) AS VARCHAR) 
END

Where [@field:Date_field] should be replaced with your field name.