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 derfloh 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
Joined
Mar 20, 2002
Messages
2
Location
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
  • Locked
  • Solved
Split Function not working
Replies
3
Views
800
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question Question
Find unique rent amount and date this was first charged
Replies
4
Views
1K
dhookom
dhookom
Drago1920
  • Locked
  • Question Question
Finding the lowest date
Replies
2
Views
626
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
rdpress
  • Locked
  • Question Question
Question Open Shellling to File Explorer
Replies
3
Views
484
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top