Forum Discussion
Calculate a future date from a date column
Hi Experts
I am trying to calculate a future date (3 months) from the last appointment date for our users. This will allow us to cancel membership 3 months from the last appointment. My summary table data looks like this
I now need a column which provides the date 3 months from the last attended appointment. I have tried the dateadd function but get an error.
thank you in advance
Hi Elisa112 ,
amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.FutureDate = EDATE ( 'Table'[Last appointment date], 3 )Result is as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
amitchandak thanks for your help as well. I am going to look at your solution to understand this method.
Hi Elisa112 ,
amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.FutureDate = EDATE ( 'Table'[Last appointment date], 3 )Result is as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
