May 06 2022 12:39 PM - edited May 06 2022 12:39 PM
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]
May 06 2022 01:22 PM - edited May 06 2022 04:03 PM
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