CurrentDate related issue
Question

Hi,

I am facing one dificulty, I need to minus the 1year and 3 month from the Current Date. Anybodyknow the formula

Thanks,
nave

Hi Nave, you can use the AddYears and AddMonths functions with negative values

for example AddYears(#2021-04-19#, -1) = #2020-04-19 00:00:00#

Hope this helps

Hi Nave,

Just to give you a direction to research- If the requirement is fixed for 1 year and 3 months specifically, you can try something like subtracting 15 months from currdate(). Try in that direction.

Also, see if below links are useful.

https://www.outsystems.com/forums/discussion/8679/subtract-days-from-date/

https://www.outsystems.com/forums/discussion/7892/how-do-i-know-the-difference-between-two-datetime/


Hi Nave,

AddMonths(CurrDate(), -15)

Hi Nave Jothi,

Please let us know which solution worked for you for reference.

Thanks,

Vani


Hi Nave Jothi

You can use below formula

NewDate(Year(AddYears(CurrDate(),-1)),Month(AddMonths(CurrDate(),-3)),Day(CurrDate()))
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.