Announcements
Hello All,
My requirement is I wanted to create an date object with specific day, month and next year dynamically.
e.g. 30th April 2022. here 30 and April will be fixed ,year will get changed based on current year.
Please help
Thanks in advance.
@kanchankumbhar
This should work for you.
Date(Year(Now()) +1, 4, 30 )
Or if you're using more dynamic of month and day (i.e. not specifically just April 30) then you can use a formula such as this:
DateAdd(Now(), 1, Years)
I hope this is helpful for you.
Yes it works for me.
Thank you so much.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 85
WarrenBelz 76 Most Valuable Professional
Kalathiya 38 Super User 2026 Season 1
