Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have Date column, i need to get previous year date,
For ex: i have 01/01/2014, i need to get 01/01/2013,
Please help how to write a formula at script level
Thanks in advance
Hi,
You can use AddYears() or AddMonth()
like
AddYears(dateField,-1)
or
AddMonths(dateField,-12)
Regards