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 IamaSherpa 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
Apr 2, 2000
7
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
need help with syntax for a date
Replies
3
Views
201
dhookom
dhookom
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
172
clevercat88
clevercat88
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
421
atadbitslow
atadbitslow
kmsohn
  • Locked
  • Question
Reservations prevent double booking on same date-Access
Replies
1
Views
135
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
Can't call procedure on Report... Working on detecting out of date objects for auto update
Replies
3
Views
135
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top