Forum Discussion
Post Prodigydatediff months returning incorrect values
Hi akhaliq7 ,
Regarding your question, 'DATEDIFF' calculates the difference between two date months. Even if 'EndDate' is the first day of the new month, it counts as an additional month. You can modify your expression.
Column = VAR _a = DATEDIFF([start date],[end date],MONTH) VAR _b = IF(DAY([end date]) >= DAY([start date]) , _a ,_a - 1) RETURN _bIf my understanding is wrong, please state your expected outcome.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi akhaliq7 ,
Regarding your question, 'DATEDIFF' calculates the difference between two date months. Even if 'EndDate' is the first day of the new month, it counts as an additional month. You can modify your expression.
Column =
VAR _a = DATEDIFF([start date],[end date],MONTH)
VAR _b = IF(DAY([end date]) >= DAY([start date]) , _a ,_a - 1)
RETURN _b
If my understanding is wrong, please state your expected outcome.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Prodigythanks Anonymous