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

endOfMonth function

Status
Not open for further replies.
tziviak

tziviak

Technical User
Oct 10, 2002
128
US
Is there a function (as in microsoft excel) to check if a certain date is the last day of the month?
thank you
 
Sort by date Sort by votes
Nothing specific...I've always used:

EOM: CDate(Month([DateField]) & "/1/" & Year([DateField]))-1

That's to show the EOM date...you can use it to compare to a date as well if needed. Hope that helps.

Kevin
 
Upvote 0 Downvote
Substitute a field or variable name for DateExpression:
Month(DateExpression) <> Month(DateAdd(&quot;d&quot;,1,DateExpression))

Duane
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Get a named Field Value from Report via function call in Report Control source.
Replies
3
Views
251
dhookom
dhookom
saqassemi
  • Locked
  • Question
max function in report 1
Replies
1
Views
136
combo
combo
JimStrand
  • Locked
  • Question
DoCmd.SendObject Compile Error - Sub Or function Not Defined 1
Replies
5
Views
229
JimStrand
JimStrand
lrdave36
  • Locked
  • Question
Can You Exclude Amounts From a Sum Function on Report? 1
Replies
2
Views
97
lrdave36
lrdave36
Ray1127
  • Locked
  • Question
Min function Question
Replies
1
Views
67
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top