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!

Empty Date Field

Status
Not open for further replies.
churdle

churdle

Programmer
Joined
Apr 2, 2000
Messages
7
Location
US
How do i test for an empty date field? i have a short date<br>field in my table...i want to test if its empty (no entry made)...if i test for
 
Sort by date Sort by votes
Well what about Isnull(Mydate)<br>OR check the length<br>If Len(mydate) = 0 then <br>....
 
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
599
dhookom
dhookom
clevercat88
  • Locked
  • Question Question
Field in table will not filter - info update
Replies
0
Views
374
clevercat88
clevercat88
atadbitslow
  • Locked
  • Question Question
comparing fields, one populated with data and one blank
Replies
8
Views
1K
atadbitslow
atadbitslow
kmsohn
  • Locked
  • Question Question
Reservations prevent double booking on same date-Access
Replies
1
Views
361
Andrzejek
Andrzejek
lameid
  • Locked
  • Question Question
Can't call procedure on Report... Working on detecting out of date objects for auto update
Replies
3
Views
407
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top