hello i need your help
I am creating a payment table, I need the next row to give me the same payment date but with one more month. For example, I start my month on 12/11/2022, I contract 6 months, I need to be given the following dates
01/11/2023
02/11/2023
03/11/2023 etc Thank you for your valuable help
Hi Steve,
this and using the following expression date(CONCATENATE(MONTH([Add Date])+1,"/",DAY([Add Date]),"/",YEAR([_THISROW].[Add Date])))
with a loop, the problem is when the year is greater than the current year
EOMONTH([Fecha], 0) + DAY([Fecha])
2 Likes