Hello,
Iโm new to this guys. Iโm trying to set a month from an specific date, 2 month, 3 month, etc. for instance, if i select sep 6, 2021, i want to show in another column oct 6, 2021, in the following column nov 6, 2021.
Iโve tried using EWOMONTH([date], 0) + DAY([date])
It works the first time, but when i try taking the last column and try writing this same code. It gives me the next month but 2 days before.
Attached is a picture
What exactly does this mean, what is the expression used for the last column shown?
Why donโt you just adjust the 2nd argument of EOMONTH()?
EOMONTH( [date] , 1 ) + DAY( [date] )
I tried. It doesnโt work either.
date1 = sep 7, 21
date2 = EWOMONTH([date1], 0) + DAY([date1]) = oct 7, 21
now when i try this
date3 = EWOMONTH([date2], 0) + DAY([date2]) = Nov 5, 21
I would like:
date3 to be Nov 7, 21.
date4 to be dec 7, 21.
get it?
Can you help?
I thought โEWOMONTHโ (with a โWโ) was just a typo when you first wrote it, and you meant โEOMONTHโ. This is actually the first time Iโve ever even heard of the EWOMONTH expression! Are you sure thatโs the expression youโre wanting to use, instead of simply EOMONTH?
Still get the same results.
Works fine for me:
Same results with either expression for date3:
for some reason now itโs working fine for me as well. weird. Thanks men for your time!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |