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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

last day of current month 1

Status
Not open for further replies.
wdu94

wdu94

Programmer
Aug 15, 2001
61
US
Hello,

Would you please tell me how to get "last day of current month" in the unbound box?

Thank you very much for your help.
Jeannia
 
Sort by date Sort by votes

Enter this in the text box.

=DateSerial(Year(Date()),Month(Date())+1,0) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
12 Month Rolling Average 2
Replies
15
Views
758
Swi
Swi
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
884
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
580
JimStrand
JimStrand
caykamanj1966
  • Locked
  • Article
currentWeek excluding weekends
Replies
6
Views
256
strongm
strongm
rudolfelizabeth
  • Locked
  • Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
255
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top