Announcements
I need some help with trying to display the previous month in an input text value. I know the current month is Text(Today(),"mmm") but how do I get the previous month?
Hi @Anonymous,
You can use the DateAdd function with negative values:
Text(DateAdd(Today(),-1,TimeUnit.Months),"mmm")
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
Yes, it does. Thank you !!
How would I convert this result to a number to store in a variable?
I was using
Month(Now())
to get the number of the month, but need to subtract 1 month from the result.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 320
Mohsin Ali 246