The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Sep 06, 2022 01:37 PM
I have 2 date fields and would like to calculate the midpoint between the two (as a date). I have tried a few the NGS bit not had any success. Any ideas?
Solved! Go to Solution.
Sep 06, 2022 02:55 PM
Maybe you need to be more accurate than this:
DATEADD(start, DATETIME_DIFF(end, start, 'days')/2, 'days')
Count the number of days between two dates, divide by 2, add that number to the start date.
Sep 06, 2022 02:55 PM
Maybe you need to be more accurate than this:
DATEADD(start, DATETIME_DIFF(end, start, 'days')/2, 'days')
Count the number of days between two dates, divide by 2, add that number to the start date.
Sep 08, 2022 03:17 AM
Thanks. That worked a treat and not something I would have come up with. :slightly_smiling_face: