#1
|
|||
|
|||
Custom fields formula
Hello,
I'm new to Formulas in custom fields and I was wondering if anyone can give help me figure out how to create a formula to display the start date with the format mm/dd, the finish date with the same format and a text. What I have so far is: [Start] [Check] [Finish] after hitting Ok i get an error message saying that there is a syntax error. Start: Start date Check: Custom text Finish: Finish date Please help |
#2
|
|||
|
|||
So I was able to set the formula right [Start] & "- " & [Text1] & "- " & [Finish] the only thing I'm missing is to be able to change the date format from [Start] and [Finish] to mm/dd
|
#3
|
|||
|
|||
I figure it out. Here is the formula in case someone needs it ProjDateConv([Start],pjDate_mm_dd) & " - " & [Text1] & " - " & ProjDateConv([Finish],pjDate_mm_dd)
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom fields used in the Compare Function | OTPM | Project | 3 | 03-02-2015 06:43 AM |
Contact custom fields not showing | Hmcrunchy | Outlook | 0 | 08-28-2013 03:54 AM |
Tasks Import ( Custom fields) | VidyaR | Outlook | 1 | 02-13-2013 07:01 AM |
Delay prediction formula for custom fields | Imagios | Project | 5 | 04-25-2012 06:32 AM |
Stumped on Grouping with Custom Fields... | ViperMan | Project | 1 | 06-22-2011 01:31 AM |