Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get the current month value

Status
Not open for further replies.
nikol

nikol

Programmer
Apr 12, 2005
126
US
How can I get the current month value "June" & the last month"May
 
Sort by date Sort by votes
//{@currentmonth}:
monthname(month(currentdate))

//{@lastmonth}:
monthname(month(dateadd("m",-1,currentdate)))

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
114
Corinne30
Corinne30
Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
112
Corinne30
Corinne30
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
630
doodledump
D
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
193
BradCustom
BradCustom
AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
430
AleXSR700
AleXSR700

Part and Inventory Search

Sponsor

Back
Top