Skip to content

Instantly share code, notes, and snippets.

@rdapaz

rdapaz/MSProjectUseRelativeDates.txt

Created April 12, 2018 03:26
Show Gist options
  • Save rdapaz/9df7b8a78ad1469f4dfe85b42f87c924 to your computer and use it in GitHub Desktop.
Save rdapaz/9df7b8a78ad1469f4dfe85b42f87c924 to your computer and use it in GitHub Desktop.
Download ZIP
MSProject Use Relative Dates
Raw
MSProjectUseRelativeDates.txt
In a Custom Text Field, create a formula such as:
Start:
"T" & IIf(ProjDateDiff(#16/04/2018#,[Start])>=0,"+","") & ProjDateDiff(#16/04/2018#,[Start])/480 & "d"
Finish:
"T" & IIf(ProjDateDiff(#16/04/2018#,[Finish])>=0,"+","") & ProjDateDiff(#16/04/2018#,[Finish])/480 & "d"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment