We need an expression that can calculate date based on number of months that we input.
for example
date: 21.06.2021
number of months:18
result date : date + 18 months (exact date)
You may find your desire here:
nope tried it, but tnx.
You may want to look further to the previous link.
Assuming:
According to this documentation, which comes from previous link:
What about:
EOMONTH([date], [offsetMonth]-1) + 1 + DAY([date])
Hi, tnx this works…
Yes.
You may want to remove the +1 though.
So, correct expression will be:
EOMONTH([date], [offsetMonth]-1) + DAY([date])
I was doing it on a sandbox app to give it a try, as you said initially that didn’t work
Happy to help
did that it worked like a charm…
Thanks a lot
So you didn’t really try?
yea i did, read everything that was there and tried what seamed to be ok, but in my case it didn’t work until Aurelien wrote that massage with actual code.
and it was different link
Thanks again @Aurelien, you are the best
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |