HI, i need to calculate -2 month for a date (eg. 1/10/2018). Now i tried with in the other i used
CONCATENATE(“1/”,MONTH([Invoice Datel] -3),"/",YEAR([Invoice Date]))
The problem is for gen and feb, because the system maybe couldn’t
calculate 1(Gen) - 2(Oct)
How can i resolve it?
+Steve Coile @Aleksi_Alkio