Dear Community,
I am working on a delivering application.
Our client choose a subscription for the delivering. The option are :
Every week
Every 2 weeks
Every Month.
When the day of delivering is today, I would like to see my clients on the first page.
I don’t know the method to generate all the dateS of delivering (for the next 2 years) per client based on the first day of delivering. Thank you for your help !
For weeks, I think it can work like this with Math columns:
With D being the date the subscription starts, N being the Now value.
About month, how would you handle the cases like this: User starts subscription on January 30th but there’s no February 30th?
Thanks a lot for your answer. I also have the right formula with https://www.youtube.com/watch?v=DkcLP9ZI6V4 (date calculation)
I don’t know how to have 1 column with all the delivering days per clients from one table with all the date. Date difference excluding weekends and bankholidays - #3 by Darren_Murphy (calendar with bank holiday)
So what have you got so far? If you have columns ready, the last thing you need to add is an if-then-else column to return the date based on the subscription type, if I understand you right.
Can you explain more about the bank holidays part? Do you want to integrate that as well? It would be much more difficult.
Dear ThinhDinh,
thank you for your reply
I think that with the video Date difference excluding weekends and bankholidays - #3 by Darren_Murphy here I may find my answer.
I will let you know the solution when I find it. Working with dates, it is a challenge !
Did this end up solving it for you? Curious!