Forum Discussion

eilidh3's avatar
eilidh3
Frequent Visitor
6 years ago
Solved

Calculating future dates from a project start date

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 🙂  

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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]))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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]))