What to use in Custom SQL field:
ROUND(DATEDIFF(DD,[Table: Field Date1],[Table: Field Date2])/30,0)
Example:
where
[Table: Field Date1] = [Assignment: Start Date]
[Table: Field Date2] = [Assignment: Actual End Date]
Custom SQL fields - Command to calculate duration in months between two dates
What to use in Custom SQL field: ROUND(DATEDIFF(DD,[Table: Field Date1],[Table: Field Date2])/30,0) Example: where [Table: Field Date1] = [Assignment: Start Date] [Table: Field Date2] = [Assignment
Updated over 2 weeks ago