Adding Months Would be nice to simply add mo...

(Fabian Weller) #1

Adding Months

Would be nice to simply add months like with the EDATE funktion in EXCEL, or like shown in this Video:

https://www.youtube.com/watch?v=86M3TCpxk2Q

(Aleksi Alkio) #2

You can do the same with the concatenate and then choose the Date as a field type.

(Aleksi Alkio) #3

It’s not as simple as with Excel or gSheet, but it’s doable.

(Fabian Weller) #4

@Aleksi_Alkio Thank you. But when I add 13 months, it will not increase the year.

When I have [DateTime] = 01/30/2000 and I do DATE((MONTH([DateTime]) +13) & “/” & (DAY([DateTime])) & “/” & (YEAR([DateTime]))) It should give me 02/30/2001. But the result is just nothing, because it calculates 14/30/2000 and that is not a date.

(Aleksi Alkio) #5

You need to check from the month column is it 12 or more and then add more years. You don’t need to do the same with the Days because when you have calculated the month and year, you can just add those days.