Can someone help with time and date function?

[ns_soft_studio1]

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)

[Aurelien]

Hi @ns_soft_studio1

You may find your desire here:

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[ns_soft_studio1]

nope tried it, but tnx.

[Aurelien]

Hi @ns_soft_studio1

You may want to look further to the previous link.

Assuming:

• [date] is your initial value
• [offsetMonth] is the number of months

According to this documentation, which comes from previous link:

help.appsheet.com

EOMONTH()

Date of last day of a month from Date or DateTime

What about:
EOMONTH([date], [offsetMonth]-1) + 1 + DAY([date])

[ns_soft_studio1]

Hi, tnx this works…

[Aurelien]

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

[ns_soft_studio1]

did that it worked like a charm…
Thanks a lot

[Steve]

ns_soft_studio1:

nope tried it, but tnx.

So you didn’t really try?

[ns_soft_studio1]

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