Forum Discussion

Wooniwooni's avatar
Wooniwooni
Copper Contributor
May 06, 2022

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

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]

 

 

  • John-project's avatar
    John-project
    Silver Contributor

    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

Resources