Displaying Planned Completion Time of Day in a Calendar

[William--]

I'm developing a task calendar for a team. They want the calendar to display a specific category of tasks, and want the label to read "Name - Time" where Name is the task's project name, and Time is the time of day set for the task's planned completion. I don't know of a way to specify the display format for Planned Completion - by default it is MM/DD/YY. I have a custom form attached to the tasks that will be displayed, so I added a calculated field that would capture the planned completion time and could be used in the label on the calendar: CONCAT(HOUR(Planned Completion Date),":",MINUTE(Planned Completion Date)) This *kind of* works, but isn't pretty. If something is due at 5:00pm, it displays as "17:0" I don't mind the 24 hour clock (not so sure about the users...), but the missing zero is really annoying. Any solutions out there for extracting the planned completion time of day and specifying how it is formatted? William English

[Doug_Den_Hoed__AtAppStore]

I think you're nearly there, William, and suggest this tweak to your calc: CONCAT(HOUR(Planned Completion Date),":",RIGHT(100+MINUTE(Planned Completion Date),2)) Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[William--]

Gold Star for you today, Doug! I went ahead and took it a step further, because I *know* it will be asked by the users anyway... (corrected) IF(HOUR(Planned Completion Date)<13,CONCAT(HOUR(Planned Completion Date),":",RIGHT(100+MINUTE(Planned Completion Date),2)," ","AM"),CONCAT((HOUR(Planned Completion Date)-12),":",RIGHT(100+MINUTE(Planned Completion Date),2)," ","PM")) Thanks!! William English