curtis
Sunday, March 25, 2012
comparing getdate()
hi I have done this before but can't seem to recall now ...I want to compare a field in my table with getdate() the field type short date which also has the time stamp...doing field_date > getdate() does not work to get data of today...can someone help!if a time is not provided when the date is entered, it defaults to midnight (when it first becomes "today"), so sometimes that can throw these types of queries off.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment