DATE HI, i need to calculate -2 month for a...

(Mark Pathfinder) #1

DATE

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

(Mark Pathfinder) #2

I Tried also

CONCATENATE(“1/”,MONTH(TODAY() -60)-1,"/",YEAR(TODAY() -60))

(Steven Coile) #3

Last day of this month:

EOMONTH(TODAY(), 0)

Last day of next month:

EOMONTH(TODAY(), 1)

Last day of last month:

EOMONTH(TODAY(), -1)

First day of next month:

EOMONTH(TODAY(), 0) + 1

First day of this month:

EOMONTH(TODAY(), -1) + 1

First day of last month:

EOMONTH(TODAY(), -2) + 1

One month from today:

EOMONTH(TODAY(), 0) + DAY(TODAY())

Today:

EOMONTH(TODAY(), -1) + DAY(TODAY())

One month ago:

EOMONTH(TODAY(), -2) + DAY(TODAY())

(Mark Pathfinder) #4

+Steve Coile Tx, it works

(Marc Dillon) #5

Great examples Steve! Commenting so I can find this later.