
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Get the Current month and year
Hello Friends
As I need to store the current month and Year in a variable, what is the function available to get it.
Regards
Chriss.....
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
vCurrentYear= year(today())
vCurrentMonth= month(today())
Regards
Apurva

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Apurva,
Thanks for your reply, my requirement is I need to store the Month and Year in a single variable
like vCurrentMonYear = June 2012. is it possible ....
Regards
Chriss

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
use this-> vCurrentYM= monthname(today())
regards
Apurva

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Apurva............

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Apurva,
I need one more favour Using Monthname(today()) I can get the Current Month and Year but when i try Monthname(today()-1) to get the previous month its not working..
Please help me...
Regards
Chriss


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Try this =Date(MonthName(Today())-1,'MMM YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Chris
No that will get the month name for yesterday. For the previous month use
MonthName(AddMonths(Today(), -1))
Regards
Jonathan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
use this
=MonthName(addmonths(today(),-1))
Regrds
Apurva

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, its works.... thanks a lot Apurva...

- « Previous Replies
-
- 1
- 2
- Next Replies »