how to compare date

[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.

 

[Nikos Yannacopoulos]

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

 

[Van T. Dinh]

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

Check Access VB Help on the above function.