Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Im looking to do a calculation that will provide me with future 'no later than' dates for a survey.
I have a project start date (01.01.20) and project end date (31.12.20) and want a calculation that will provide the half way date (06.20) and another one to calculate one month after the project end date.
I'm presuming this is pretty easy to do but cant find anything online (although likely its my search terminology)
Thanks in advance 🙂
Solved! Go to Solution.
@eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2)
one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))
@eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2)
one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |