AnsweredAssumed Answered

How do you format Dates for Portlet display?

Question asked by Lowell on Aug 28, 2015
Latest reply on Aug 28, 2015 by urmas

I have a request from a user to "concatenate" dates into a single field.  I can format the date as "MM/DD/YY", but I am trying to trim the leading zeros or format the Date with leading zeros to have both formats match.

 


By default, Clarity displays dates without the leading zeros (1/1/15)

 

When I have the To_Char(TSK.PRFINISH,'MM/DD/YY'), the date shows as 01/01/15

 

Is there a way to either display the Clarity "Date" format as 01/01/15?

 

 

 

Or... Is there a way to display the To_Char(date,'MM/DD/YY') as 1/1/15?

 

 

 

 

 

 

 

 

 

 

 

 

Outcomes