how to compare date

  • Thread starter Thread starter Tausif Alam
  • Start date Start date
T

Tausif Alam

Hi all GURU,

I have a field date_stamp stores date and time. I would like to compare only
date... how can i do it...

Thankx

Tausif.
 
Tausif,

Date/time fields in Access are really numeric fields of type Double, where
the date is the integer part and the time is the decimal part, only they are
by default formatted as some date format for display, depending on the
regional settings on your Windows installation. So, if you want to compare
on the date part only, just use the Int() function on the date_stamp field
(Int([date_stamp]).

HTH,
Nikos
 
You can obtain the date component of a DateTime value using the DateValue()
function.

Check Access VB Help on the above function.
 
Back
Top