AnsweredAssumed Answered

Set 1/1/18 as 01/01/18

Question asked by chuckburr on May 4, 2018
Latest reply on May 6, 2018 by bigtom

Is there an easy way to set 1/1/18 as 01/01/18 with leading zeros added if the user does not enter them?

 

I do not mean formatting the field with leading zero, I mean setting another field (timestamp) with the leading zeros included that the user did not enter.

 

---

 

Solution:

 

Case(GetAsNumber ( Month(Trades::Date_Global)) < 10; "0") & Month(Trades::Date_Global) & "/"  &

Case(GetAsNumber ( Day(Trades::Date_Global)) < 10; "0") & Day(Trades::Date_Global) & "/" &

Year(Trades::Date_Global)

Outcomes