I need to create a formula field to only show the day and month of a date field.
Let's say the date field is 06/07/2021. I want the formula field to show 06/07.
Any thoughts on what formula to write? Also, what would the return data type for the formula field be?
Thanks for any assistance,
Emmanuel
11 件の回答
I would add an LPAD Funtion to the formula in case this field is ever used in a Report or List View (or might be) LPAD(TEXT(MONTH( DateField )),2,"0") + "/" +
LPAD(TEXT(DAY(DateField)),2,"0")
