How to change Task Finish date format created by custom filed on gantt chart?

Copper Contributor

I created one text custom field like below, but the date format of Finish is showing like 1/24/2024 Webnesday 5:00:00 PM. I just want to display simple type format, DD/MM or DD/MM/YY.

 

Could you please help me how to change Task Finish date format created by custom filed on gantt chart? 

  

 - Custom field:    [Name] & "," & [Finish]

 

Wooniwooni_0-1651865723466.png

 

1 Reply

Woniwooni,

If your custom field is a date type field (e.g. Date1, Start1, etc.) then the format is determined by the option setting under, File > Options > General > Date format, and that's the only way to change it.

 

However, if you still want your general format for dates to include the date, weekday and time but want your custom field to only show "mm/dd" or "mm/dd/yy" then you will need to create your custom field as text (i.e. Text1, etc.)

Text1 = [Name] & " , " & format([Finish],"mm/dd")

Hope this helps
John