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!

Date Function Question

Status
Not open for further replies.
Thedoc56

Thedoc56

MIS
Mar 20, 2002
2
US
I am trying to write an expression that will check a date ("POL_EFF") that is already in the database and add one month to it. What am I doing wrong in my syntax?

If Month(Date) = Month("POL_EFF")
Then DateAdd("m", 1,Month( "POL_EFF"))
 
Sort by date Sort by votes
The correct syntax would be :
If Month(Date) = Month("POL_EFF")
Then DateAdd("m", 1,[POL_EFF])
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Split Function not working
Replies
3
Views
203
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
571
dhookom
dhookom
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
330
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
746
Andrzejek
Andrzejek
rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
183
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top