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?

Status
Not open for further replies.
Anointed

Anointed

Programmer
Joined
Oct 28, 1999
Messages
1
Location
US
Why does the DATE() function only return October 22, 1999?
 
Sort by date Sort by votes
I think its cos date() requires a parameter to "date". With no parameter it takes date() as date(now()).
 
Upvote 0 Downvote
Are you trying to convert a string to a date? If you are CDate() is a better function than Date().
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question Question
need help with syntax for a date
Replies
3
Views
595
dhookom
dhookom
kmsohn
  • Locked
  • Question Question
Reservations prevent double booking on same date-Access
Replies
1
Views
342
Andrzejek
Andrzejek
JackSapsford
  • Locked
  • Question Question
Microsoft Access 2000 - Function Is Not Available...
Replies
12
Views
1K
combo
combo
lameid
  • Locked
  • Question Question
Can't call procedure on Report... Working on detecting out of date objects for auto update
Replies
3
Views
405
lameid
lameid
digitalias
  • Locked
  • Question Question
Temporarily retain Date value in data entry form
Replies
0
Views
311
digitalias
digitalias

Part and Inventory Search

Sponsor

Back
Top