TEXT(YEAR([Opportunity].CloseDate))&
TEXT(MONTH([Opportunity].CloseDate))&
TEXT(DAY([Opportunity].CloseDate))&'CC'
However, this provides my date in yyyy/m/d format. I would like it to be yyyy/mm/dd (ie with the leading zeroes). How can I change this to make the date in the preferred format? Thank you!
답변 4개
Hi Bill I wonder if your requirement might be met by using the DATEVALUE() function? Is the custom field Date format? If not - why not :)?
